Import error handling

[Peps]

Hi There,

I have a table that is reciving data from Excel, there are occasions when the data imported dosent correspond to the field criterias. (text into a number fields)

The problem is that My DB has stopped creating the Import Error tables and is now showing standard error msgs like:


The application was unable to append all the data to the table.The contents of 9 Record(s) were deleted, and 0 Records(s) were lost due to key violations.


I'd like to know how I can substitute the standad error message and get my Db to create the error tables like it was doing before.

Thanks, Peps

 

[BNPMike]

If it's just text in number fields, change the import sepcification so all fields are treated as text. You can then change them to numbers once they are in Access.