Access files A good upper bound on the size of Access databases (mdb or accdb) is 5 MB. If you upload a larger file, you may get an error when you try to download it because the file will be too large to be read into bytes and streamed to you. This is a security feature we have implemented so that no one other than you will ever be able to download your database, but can cause this error. Text/CSV files We are currently experiencing a technical issue that prevents us from allowing you to upload more than 3000 records in a text/csv file. If your data file is larger than this, you should create an Access database (mdb or accdb) and upload that for processing instead.
The preferred file format is an Access database, Office 2003 (mdb) or Office 2007 (accdb). The reason for this is that we create a temporary database for you if you upload another file format (txt/csv), and depending on the particularities of your text file file, we may fail to read it in some cases. Therefore, it is easier for everyone if you just upload an Access file because we don't have to do the conversion.
You have to upload one or more databases to process before you can use the batch processing services.
You have to validate your databases on the upload page before your databases will be visible on the batch processing pages. This ensures that we are able to open and read your data.
This Microsoft Office page explains the basics of delimited text files. If you follow the guidelines listed for importing data into an Access database, your data should pass validation without any problems. To avoid common mistakes, please ensure the following about your data files: Rank File type Check 1 Text and CSV Make sure that your first row contains column headings 2 Text and CSV Make sure that your data values do not contain your separator character 3 Text, CSV, and Access databases (mdb, accdb) Try not to use spaces in file names, table names, and/or column names Here are some pretty standard database guidelines 4 Access 97 Access 97 does not support the decimal datatype, so you will run into problems if/when you click on the auto generate button to create output fields in your database. Access 97 users will need to create the output fields before uploading databases for use in the batch processing.
Yes. All services use the same file formats. For example input data files please review the geocoder input sample files and substitute the applicable fields for the service you wish to use.
