Characters found after end of SQL statement." is the run-time error I got when I tried your code. Your code, however, does work for a singe SQL statement.
The reason for this exercise is to programmatically transfer data from Excel into Access. I have successfully concatenated row...
I am trying to execute multiple INSERT SQL statements in a single MS Access query. It appears that MS Access allows only one SQL statement within a query. This is a limitation not found in other MS database programs like Foxpro. Any suggestions on batching multiple SQL statements in Access...
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.