Home |
Search |
Today's Posts |
#1
|
|||
|
|||
query problem after changing to SQL server
I use queries in Excel to create custom reports out of our
accounting database. We recently changed to an SQL server and now I can't run any of these reports since the address of the database changed. Any suggestions?? I can't figure out a way to access the query to edit the address since I don't have each query saved outside of the spreadsheet. |
#2
|
|||
|
|||
You need to change the Querytable objects' connection string and/or SQL
text. See: http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Charting My Data -- | Charts and Charting in Excel | |||
Excel Query Via Sybase | Excel Discussion (Misc queries) | |||
Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
Problem with Query | Links and Linking in Excel | |||
MS Query/ODBC/SQL problem | Excel Discussion (Misc queries) |