How do I get an Import Errors Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've set up a table structure and imported a text file in.
1 record is rejected due to primary key violations, but I don't seem to get
an Import Errors Table.
How do I get this? I've looked all through help and tools/options etc..
I'm running Access 2003.
Thanks.
Jim
 
AFAIK, you won't. import error tables track "bad" data, such as data that
won't fit into a field because it's the wrong data type - for example, text
that cannot be imported into a field with a Number data type. violation of a
unique index does not mean the data is "bad", it just means it doesn't
follow the rules that you set up for that table.

hth
 
Back
Top