Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative Path in Connection String
I am using Excel 2007 to import data from another Excel workbook using
Microsoft Query 2000. The solution works well with a fixed path, but I would like the connection string to use a relative path (for example the current directory) so that the files can be copied to a different location and still function. I have seen a number of web questions about this topic, but most involve a programming solution. Is this possible just using Excel? Eg. to specify an ODBC connection string that would solve the problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative path in database query connection string | Excel Discussion (Misc queries) | |||
Relative Path to a Folder | Excel Discussion (Misc queries) | |||
How do I use a connection string? | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Absolute vs Relative path | Excel Discussion (Misc queries) |