![]() |
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