I have extracted geobase data from one programs database and using excel want to import it into another geobase database so I can run some SQL scripting to undertake some comparison checks. The problem is the two have silghtly differring formats. For example
in the first table the address is displayed as below for example with the following columns
Address, Town, Post Code
1 Thames Street, Camden, E12
In the second table where the data is being imported into, it is displayed with additional columns;
House Number, Street Name, Street Type, Town, Post Code
1, Thames, St, Camden, E12
I can extract the numerics easily enough, but not sure how to get them into the House Number column. In the second table, the program uses abbreviations to identify the street type so I need to also convert the existing ones. e.g
Street = St
Close = Cl
Drive = Dr
Not sure if this would be done by a CASE statement? I have some VBA knowledge but at the moment not enough to attepmt this in any reasonable space of time.
Can anyone assist? there are some 600,000+ records to transpose and anyway of saving a bit of work would be appreciated
Last edited by OldMike; January 31st, 2012 at 04:05 AM..