csv datafile errors do not create error table Roger1606 23.09.2006 11:49:02 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.

RE: csv datafile errors do not create error table Tom Wickerath 28.09.2006 07:08:01 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 __________________________________________ "Roger1606" wrote: [Quoted Text] > 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.