locked
Excel Macro accessing Access Database RRS feed

  • Question

  • I have created SQL code in the Excel Visual Basic module to query a MS Access database.  The code works fine on my machine (runs the code and brings back the data to a spreadsheet) and others that have MS Access on their machines.  We wrote the code for the large percentage of employees that do not have Access so they could query the database.  The code, however errors out on any machine that does not have Access.  Is there a way around this.  We have the "reference to Microsoft DAO 3.6 Object Library" in the excel file but that alone is apparently not enough.  Thanks for any help out there.
    • Moved by Martin_Xie Tuesday, April 13, 2010 2:48 AM Redirect to appropriate forums for better support. (From:Visual Basic General)
    Monday, April 5, 2010 6:53 PM

Answers