🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

VBA Access and Monarch-Using JetExportTable

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

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?

 

Find more posts tagged with