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
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