Felix Atagong
02-14-2008, 07:08 AM
I get daily Excel (2000) files containing +/- 100 addresses in the uk. I need to compare the postal code (and city) on this file with the official British Post database that is 80 MB big (in csv) and contains about 1,600,000 entries. (This to have the official spelling of the city name, BIRMINGHAM not B'HAM etc... and to see if the right postal code has been given).
I suppose it will be faster to lookup the postal codes when they are in a database such as msaccess, not csv. Are there 'faster' databases (SQLite?). I'm basically looking for the fastest way to do a lookup...
I suppose it will be faster to lookup the postal codes when they are in a database such as msaccess, not csv. Are there 'faster' databases (SQLite?). I'm basically looking for the fastest way to do a lookup...