Trying To import data from Access to TD, Getting Key Violation

Database
Enthusiast

Trying To import data from Access to TD, Getting Key Violation

Hello,

I'm trying to import table data from an Access table via append query and keep receiving errors. I'm aware that I need to best match the data types from Access which I believe i have done, Varchar for text, DATE for date, etc.... yet i still get these errors. When I try and import a column i get "Didn't add 1495 records due to key violations" when i try and import all columns i get the Precision error/cbColdef. I am trying to import 11,000 records. Any help would be greatly appreciated! thanks!