csv datafile errors do not create error table

[Guest]

I am importing csv files which may have data errors. I was hoping to use the
error table to identify any errors due to validation rule violations, missing
data etc.
However, when the import is complete the records in error have been omited
but there is no data error table.

 

[Guest]

Unfortunately, this is by design:

(ACC2000 Import Errors Table Not Created During Failed Import
http://support.microsoft.com/?id=207789

Note: This article likely applies to A2002 and 2003 equally well.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________