| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connect a Query in MS Query top another DSN
Hi all.
Thanks for thinking together with me! I was still lokking for the option to just change the DSN info. And I guess I found the way. 1) Save the MSQuery query to a folder 2) go to that folder and right click it and select "open in Notepad" 3) Now you get some editable text. Change the DSN name AND (!!!) the server name AND (!!!!) the database name. 4) Save the file Now the MS Query query will use the other DSN and corresponding database. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| connect to access database and run a query in excel VBA | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
