Importing from Excel errors

[SteveE]

Using Access / Excel 2k
For almost 3 years we have been successfully importing from an excel file into access daily booking records (80-100) per day without any issue, sometimes if the data has been entered in excel wrong then we get errors. My problem is the source excel file has been changed we now have only a quarter of the records importing successfully but no warning from access that some have failed. I cannot find any reason why, I cannot paste the records into access as it reports wrong data types but on checking each field they are correct. I think I am having some form of hidden charaters from the conditional formatting in the Excel file but cannot find where.

Importing through the "get external data" option direct into the table

Any help or suggestions would be appriciated

Thanks in advance

 

[KenHigg]

Can you crab a chunk and biring it into Word, then have word show all hidden char's. This may reveal some kind of pattern...

???
ken

 

[The_Doc_Man]

Another thought - a couple of fonts have special symbols that would reveal control characters if present. If you could momentarily show the characters in that alternate font, you would see what is bugging you, maybe.

Also, get into Excel and export the spreadsheet into a text file to see how it gets formatted. You might find extra field breaks somewhere.