Import from Excel

[SteveE]

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.

Any help or suggestions would be appriciated

Thanks in advance

 

[Norie]

How are you doing the import?

 

[SteveE]

We import via the get external data option, as I said this has worked well, on the few occasions it has failed I have copy and pasted directly from the excel sheet into the required table.

Steve

 

[Norie]

Have you checked all the formats in the Excel file?

Why not import each field as text, then look at the data.

You might be able to see what is causing the problem.

 

[SteveE]

first thanks for your help.

Yeh, checked all the fields in the excel file, I,m convinced its the excel file conditional formatting thats causing the issue, if I completley re-type the a new sheet with the info from the old one then do the import No Problem.
and thats without setting the formats in the new sheet at all.