I attempted to use 'Import Export Data' tool to import an Access 2003 mdb file into SQL Server 2008r2. I didn't develop the Access file. I get an 'Error 0xc0207015 - The data source column names must be unique'
This is coming from one of the queries that accesses a few tables. What is the easiest way to see which tables need to have a column changed or edit the query? And also, too, how do I see whether other queries will have the same problem?
View Complete Post