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?
The same error as by wizard but I proceeded in the wizard and it imports, but by code doesn't import.
Yes I have one field as PK, but I cannot erase it, there must be one in the table.
Also if I do it by code I must add a field in the table called "F1" otherwise is giving to me a runtime error saying that I don't have this field "F1" in the table. But if I add this field, there is no error but the import is not done and I still have the same error I posted before.
The thing is nothing of that happens with the wizard and the import is done, with some conversion data problems, but it is done.
I managed to import the file fine but I had to create a custom import specification.
To do this run the import wizard as normal then click on advanced, change the field "Artikelnr" to a text (it was recognising this as a date which then casued errors) then press "Save as" - it will give a name "Output import specification" then ammend your code to: