I am trying to provide a report to someone that allows them to refresh the data within an Excel file. I’m using Excel 2007 and Toad for Data Analysts 2.6. I followed the directions in the user’s guide “Share Excel Linked Queries”. After writing my SQL, running the script and selecting ‘Excel Linked Query’, an Excel file opens with a workbook named ‘Query’ and no data in the worksheet. I am given an error from Toad of:
Unable to execute linked query.
Excel returned the message: “General ODBC Error”
Error code: 800A03EC
I’m not using ODBC to run the query.
Any help would be appreciated.
Thanks in advance.