Import

[SteveE]

I regulary import data from an excel sheet through a macro transfer spreadsheet, 99 % of the time without issue.

I have one field that is a formatted both in excel and the access table as text. My problem is that out of 1000 records sometime this field will contain an alfa-nurmeric ie Cov12345,TVA456877 when I have these the record just does not import, I get no warnings from access just the missing row of data.

any ideas welcome

Steve

 

[The_Doc_Man]

Do you have warnings turned off?

Does the import process create an "errors" table?

Do you have filtration criteria or ValidIf definitions in the table?

 

[SteveE]

Import Error

Thanks for the reply,
Warnings are not turned off, no import error table is created and in the tables there are no validation or filter rules.
If I copy the row from my excel table and paste it directly into the table there are no errors and he record is saved an normal. The problem only exists in the "transfer spreadsheet" method ?

Steve