If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot tables, external data sources and ODBC links
arg... yeah man im pretty much in the same boat ... all i need to do is
change the dsn system name did you have any luck? "makrug" wrote: I have a spreadsheet which contains 30+ pivot tables which have an external mdb as their data source. If I change the location of the mdb then I repath the ODBC link to the new location and manually edit the SQL code in MS Query to change the path for each pivot table. Rather tedious. I've trawled this site for some code to do this, but no luck so far. A second related question. When building external data queries using MS Query I use a pre-defined ODBC link and select that as the DSN. Now I would have thought that if the external data source moved all I would need to do is repath ODBC connection and all will be peachy fine, but this appears not to be the case. The old path is being remembered somewhere. Any help appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |