Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aNewbie

    Executing multiple SQL statements in Access

    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...
  2. aNewbie

    Executing multiple SQL statements in Access

    Thanks for the quick response. I am a newbie to MS Access, where is the best place execute this code from? Gene
  3. aNewbie

    Executing multiple SQL statements in Access

    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...

Part and Inventory Search

Back
Top