Losing rows when uploading an excel file

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
160
Hello guys,

I have a question about uploading data from excel files.
Usually, but not always, Access "eats" some rows of data when uploading them.
I have tried to check everything in these records and pretty much all seem fine in regards to the quality of data.
The strange thing is that as many times as I upload the file, Access always ignores the same lines but when I upload the file with these rows alone they are stored in the Access database without problem.
Can anyone figure out what this may be?
I always receive a "Feeder Import Error" about the first column which is "a null value in an auto-number field", but 99,9% of the records are uploaded normally.

Thanks
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Pettor

Board Regular
Joined
Aug 8, 2015
Messages
160
Please don't bother. I just found the problem. Some other columns had duplicated data and there was a code that let only one of them pass.
Case closed.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,014
Messages
5,545,497
Members
410,687
Latest member
Sunshine2020
Top