Saving Import Errors

M

Mike D

I am using VB to import Several Text Files. When I get an import error, i get
a pop up window but it does not save the data to an error table. I have
setwarnings to off and use the following code to import the txt file:
DoCmd.TransferText acImportDelim, "Equip Import Specification", "Equip",
CurDir$ & "\Equip.txt", False, ""
I want to save any import errors to a specific table that matches the name
of the file or table involved.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top