Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Switch the ODBC connection in Excel
Is there a way to switch the data source of a querry in Excel?
We have moved our reporting functions of Excel to a new server and we want to point some old reports to that new server without recreating the sheets. Is there a way to do that? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Switch the ODBC connection in Excel
Pete
You need to change the Connection property of the QueryTable object. You may also need to change the CommandText property if it contains the path. See here http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Pete Petersen wrote: Is there a way to switch the data source of a querry in Excel? We have moved our reporting functions of Excel to a new server and we want to point some old reports to that new server without recreating the sheets. Is there a way to do that? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODBC connection from Excel 2008 on Mac OS X | Excel Discussion (Misc queries) | |||
Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
How do I set up my ODBC Connection from AS/400 file in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel / Access ODBC connection | Excel Programming | |||
ODBC Connection | Excel Programming |