Creat an Error Log

[Dwight]

Hello:

The database I am constructing will frequently need to import data from Excel.

I built one central import form that allows the user to 1) select the Excel file they want to import (using the common dialog) 2) select the destination table in Access and 3) then import the data.

The Excel files will be in a pre-determined “Access import friendly” and the data will be sucked in using the TransferSpreadsheet command.

When there are errors I would like the user to be presented with a decipherable error log (have meaningful descriptions to a non-Access person) so that they can go fix the problems or at least be aware that some data did not make it.

I have looked around but haven’t come across what I need.

Question: Does anyone know of a previous thread, knowledge base article, or have code available that accomplishes what I’m describing. I’m sure it is a common subject.

I have an idea of how it can be done but I don’t think it is the best method.

Thanks

 

[Cosmos75]

Try this threads and see if they help you out any.

smercer's Error Log

Cosmos75's Errors - List & Log

Error Code Tables - Pat Hartman's example: How to use VBA build a table in Access with populate with Access Error Codes.

You might try of using Pat's code to create a table, then add a "meaningful description" field then go through each error code and add that meaningful description if the default error description isn't good enough. Than use one of the two sample databases to log that error. I haven't tried smercer's sample to bo honest (but it's probably far superior to my attempt!).

Hope this give you a starting point!