Duplicate Id's Problem while Importing access to SQL

[rajesh876]

hello,

I am in the process of migrating data from access to sql server 2005.

We have 3 separate access databases having the tables and structure.but the data is different.I have to import all this data to sql server in to 1 single database.I am able to import successfully 2 of the access databases.but the problem is that there are so many dupliactes in sql server table after importing.because of UNIQUE IDENTIFIER which is different in 2 seperate databases.Please tell me what should i do?

Suggestions are needed if anyone imported 2 to 3 access databases to 1 sql server database.I want to remove duplicates.

Thanks,

 

[HiTechCoach]

If it were me, I would combine all the data into a single Access database. Once the data is all cleaned up in an Access database, then upsize it to the SQL server.