Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing External Data Location Link in MSQuery
I have a fairly complex workbook that I used on a regular basis. The
first thing it does is get a data extraction from an ACCESS database that is located on a different computer over the LAN using MSQuery. Recently, my IT department swapped out the computer that stored the ACCESS database with a different computer (new name, new IP address, etc.). So now even though the database structure is the same it's stored on a new machine. How can I change the location that the link uses to retrieve the data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting external data from Access 2007 using msquery | Excel Discussion (Misc queries) | |||
Changing External Data Location | Links and Linking in Excel | |||
link not updating after changing source location | Excel Discussion (Misc queries) | |||
Changing the code on an external link. | Excel Programming | |||
External reference changing the link | Excel Discussion (Misc queries) |