Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a number of MS Queries which i need to point to a new SQL datasource .
On pc's both datasources are present as System DSN's. On opening existing Queries with new datasource, View/tables/criteria and Criteria menu options are supressed. New created Queries have no issue. How can i preserve Query function with a changed datasource? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating A Datasource | Excel Discussion (Misc queries) | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
How do I change the datasource location for a query in Excel 2003 | Excel Discussion (Misc queries) | |||
External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
vb and excel as datasource | Excel Programming |