How do I get an Import Errors Table

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
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error message importing excel 2
Message from importing an excel file 8
How to export table from outlook into ms access table? 0
Error while importing tables 1
CSV import error only with code 1
Importing with an Autonumber PK 1
How is a BRIO table (Section) imported into Access? 3
csv datafile errors do not create error table 1

Top