Hi All.
I tried to import data from an Excel spreadsheet that has no duplicates into Access. When I used the Access wizard to do this, I ended up with a lot of duplicates in the table. When I copied and pasted the same spreadsheet into an Access table, there were no duplicates. What is the problem? How to properly avoid duplication when importing data?
Thanks
I tried to import data from an Excel spreadsheet that has no duplicates into Access. When I used the Access wizard to do this, I ended up with a lot of duplicates in the table. When I copied and pasted the same spreadsheet into an Access table, there were no duplicates. What is the problem? How to properly avoid duplication when importing data?
Thanks