Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Puerto Rico
    Posts
    69

    Unanswered: SQL Queries in Access

    Is there any place where I can see examples of SQL queries in access VBA? I know some SQL stuff and if i find the right format i might pull out my program. I'm using ADODB in an excel workbook from where i want to automatically create/update some student info. I had no problems creating I have problems updating cause of the errors. Any idea/link is welcomed.

  2. #2
    Join Date
    Feb 2004
    Posts
    37
    You can graphically create some queries in MS Access in the query section, then look at the actual SQL query by selecting SQL View from the view menu.
    Though if you want/need to get more heavily into SQL, a good book is the only way to learn.

  3. #3
    Join Date
    Feb 2004
    Location
    Puerto Rico
    Posts
    69
    I want to use SQL from within Excel VBA. Maybe I wasn't clear sorry...

Posting Permissions

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