Excel Connnection to SQL through ODBC
Posted on 2014-07-24
My new Windows 8 laptop will not let me attach files. When I tried, it closed Internet Explorer. Unfortunately, then, I will just have to explain the issue as best as I can.
I created an Excel spreadsheet which pulls in data from SQL. So, I have both an Excel spreadsheet and a .odc file.
The customer wanted the SQL query revised. So, I revised it. When I run the query in SQL, it executes and displays data perfectly.
But, when I paste the query into the Excel spreadsheet, replacing the original query, I get the following error upon refreshing Excel:
The query did not run, or the database table could not be opened. Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again.
Thanks! Much appreciated!