Import Error Reporting

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I have several ASC File imports that occur through out the day. If the data
imported contains a mis-placed quote it will generat an ImportError table
that references the Record by row number of that has the problem.

Is there anyway to create an actual report for the user that is doing the
import that shows them the record(s) in question?

Thanks
Matt
 
Hi Matt,

IMHO the best approach would be to write code that reads the file before
trying to import it and draws attention to any problems.

Otherwise, the general idea would be to identify the ImportError table,
extract the error information from it, open the text file and extract
the offending line(s).

How's your VBA?
 
Back
Top