I have a problem when I import a file from a txt file to a access.
I use this:

DoCmd.TransferText acImportDelim, "Mendag Import Specification", "importMixing", sFic

but when the program is running the database give me this message:
Microsof Access was unable to append all the data to the table.

The contents of fields in 0 records were deleted, and 0 records were lost to key violations.
*If data was deleted, the data you pasted or imported doesn't match the field data types or the FieldSize property in the destination table.
*If records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?
And the data doesn't import.
May you help me?
Thank you