The message was stated incorrectly. I forgot to place the .txt on the end of the file name. Once the .txt was placed on the end of the file name the macro to import external worked.
I get the following message when trying to run a Macro to import external data from a .txt file.
"The Microsoft Jet database engine cannot open the file <name>. It is already opened exclusively by another user, or you need permission to view its data. (Error 3051)"
I have check...
Is there a way to run multiple SQL queries at one time. I have used a Access Macro which works great. I used the RunSQL in the macro. But now my problem is RunSQL is limited to amount of characters you can code 256. I just want to run the SQL's nine in all from a macro. I have nine tables each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.