Results 1 to 2 of 2

Thread: Article: Retrieve Data From A Database To Excel Using SQL

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14

    Article: Retrieve Data From A Database To Excel Using SQL



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Dear Ken,

    I'm having problems with the above code.
    After executing 'GetRecords', I'm getting Run-time error '-2147217865(80040e37)': Method 'Open' of object '_Recordset' failed.
    The debug highlight is set on:
    PHP Code:
    'Open recordset based on Orders table    rst.Open strSQL, cnt 
    'glob_DBPath' is directing to your Marina.mdb of your previous post (also of 7years ago
    ).
    Thank you for your posts,
    And regards my regards,
    Dito

Posting Permissions

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