Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Question Unanswered: run sql statements in a file

    In oracle, we can run a file and execute all the sql statments in it. (e.g. @c:\run.sql)

    Can we do this in Access, I have over 1000 sql statements in a file which is going to UPDATE all the tables in a access database. It's impossible to run the update statements one by one in a query. Is there any good way?

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta, GA
    Posts
    1

    running sql statements

    In VB Editor, set up a module to run your sql statements. Use object DoCmd.RunSql for each one of your sql statements.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •