Import Error Auto Redirecting

[cyspope]

Hi,

When I import an excel sheet into Microsoft Access database tables, I get a automatic [table name]_$importErrors table generated. Almost always, errors are type mismatch error. Then, I need to go manually fix the cells.

Is there a way to automatically point to excel cell(s) which have error(s)? I am trying to write a VBA code which opens an excel sheet if an "importError" table gets generated automatically after import. Then, it goes directly to a cell in the sheet where it has errors with a click of button in the Access form.

 

[llkhoutx]

Use DAO ot ADO code to single step through the errorant table, decode the error row and column, then move to that row and column in the imported table in the datasheet view.

My experience is that such errors are often innocuous.