Import Error Files - Export$_ImportErrors

[KeyserSoze]

I have created macros that import several Excel files into tables. From time-to-time, there are problems when the data in the Excel files contain values that are not compatible with the fields in the tables, thus creating import error tables in my database (i.e. Export$_ImportErrors, Export$_ImportErrors1,......).

Is there a way to identify each import error table created with the Excel file that contained the data that was imported? Is there a way to change the naming convention of these import error tables to help identify their Excel data file source?

Thanks!

 

[Andrzejek]

By “I have created macros” I understand you have some VBA code written by you.
If so, I hope when you ‘import several Excel files into tables’, first you do the validation of the data in Excel before you attempt to insert it into your tables, right?

If my assumptions are correct (they may not be…), you should end up with the valid data in your tables, and (hopefully empty) error log file with any information you need about any issues with any Excel file / row of info, etc.

Unless I am missing something here...



---- Andy

There is a great need for a sarcasm font.