CODEWITHSUNDEEP
ms-access
BIBD
BIBD

Reputation: 15414

MS Access Import Error Table

When importing data into an MS Access Database, sometimes there are errors in the formatting of the data source.

As I recall, when this happens, MS Access will put the offending row into a separate table called <something>.

What is this table's proper name?

Upvotes: 3

Views: 5826

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

Import Errors is the name of the table, followed by an integer if you have had previous failed imports. (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 pasted data.

I notice that in Access 2010, the file is called <name of import file>_ImportErrors, for example, importing try.txt would give try_ImportErrors:

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

Upvotes: 4

Related Questions