Geocoding over 1M records

Question

Hi all,

I have 1,609,214 records in a .csv file that I'm trying to geocode in one fell swoop, but I'm getting an error during the process "there was an error trying to process this table." I assumed that meant the file was too large, so I split it into two files and both geocoded fine.

Now I have two sets of geocode results in my table of contents, so I have two questions.

1. Is there a way to geocode all of my 1,609,214 records without splitting the file?

2. If not can I join my two geocode results together via arcmap into 1 set of results after I have geocoded the two split files?

I hope this all makes sense. Thanks for any guidance. I'm using the USA_ZIP4_LocalComposite locator that comes with business analyst.

BrandonPowell1 · Answer

Thank you Xander, I used the Append tool and it worked just like I wanted it to.

XanderBakker · Answer

I'm not sure if there is a limit on the amount of records that can be geocoded at once. You can however, do this in batches, as you did and "join" the files together using for instance Merge—Help | ArcGIS for Desktop , Append—Help | ArcGIS for Desktop  or loading the data About loading data into existing feature classes and tables—ArcGIS Help | ArcGIS for Desktop