ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   External SQL data (https://www.excelbanter.com/excel-discussion-misc-queries/262472-external-sql-data.html)

Dave Mc

External SQL data
 
Sorry for the lack of knowledge. I have some spreadsheets which pull data
from sql database thru an ODBC connection. Since upgrading to 2007, when I
"Edit query" on some of these spreadsheets, it starts to connect then I get a
warning saying that it is changing to database context XXX. The database it
is changing to is the one I want but the warning I get only lets me click on
OK, but the query window does not open. I have seen some documents that this
say this is just a warning but when it is reported, it stops the script from
completing. I don't have a clue what to do about this. It works OK on Excel
2003.


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com