Results 1 to 3 of 3

Thread: SQL in VBA

  1. #1
    Join Date
    Oct 2004
    Posts
    57

    Unanswered: SQL in VBA

    I want to run a SQL script pass-through from a VBA module. Does anyone know how to set up an ODBC connection within VBA?
    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think there is a website called www.connectionstrings.com that will have the answer for you
    George
    Home | Blog

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by Geremia
    I want to run a SQL script pass-through from a VBA module. Does anyone know how to set up an ODBC connection within VBA?
    Check out this website, specifically Access and SQL Part 1, 2, 3, 4, 5, & 6. It might help you.
    Me.Geek = True

Posting Permissions

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