MS Access Import Error Table

Question

When importing data into an MS Access database, errors sometimes occur in formatting the data source.

As I recall, when this happens, MS Access will put the offensive line in a separate table called <something>.

What is the name of this table name?

Answer 1

Import Errors is the name of the table followed by an integer if you had a previous failed import. (Access 2003: http://office.microsoft.com/en-us/access-help/import-or-link-data-and-objects-HP005187610.aspx?CTT=1 )

Access will create a table called Paste Errors for the inserted data.

, Access 2010 < a > _ImportErrors, , try.txt try_ImportErrors:

Error                               Field   Row
Null value in an auto-number field     id     2