My company is small and cannot afford a database expert so please keep it as simple as possible!
I've exported a sample data set of 10000 from a table containing address records from SQL 2000 to Access. This address data was badly formatted and I used address cleaning software against the Access database to clean up the fields. I then imported the sample results back into the SQL database as a temporary table.
What is the easiest way for me then to update the main address Table in SQL with the cleaned 10000 sample records without affecting the other records within that Table?
The main address Table has many dependencies in SQL so I don't want to affect anything here either.
Hope you experts come to my rescue again!