I am running VBA code in an Access database. I'd like to use JetExportTable to export the result from a text file and a model directly into the Access database I am running the code in. I have no problem sending the data to a table in a different Access database. However, I can't figure out how to send the data to a table from where the code resides.
Is it possible to send the data to a table in the same database?
The current process is to export (ExportTable) a file based on the Monarch model and import using an Access import specification. This allows for import errors to be logged. Is it possible to log import errors by using JetExportTable? If so, how is this done?