R
Richard
I have an access program with linked excel and tab delimited text files.
Since I've hand-linked all the excel and text files, the access program does
have Link Specifications for each of the tab delimited text files (but not
the excel files).
I need to run the access queries on other computers. I can copy the access,
excel, and text files to other computers. The other computers will be set up
to have the save directory structure under "My Documents".
How can I create a program that will re-establish the links to the excel and
text files on the new computers?
Note: The excel files all have column headers in the first row.
Since I've hand-linked all the excel and text files, the access program does
have Link Specifications for each of the tab delimited text files (but not
the excel files).
I need to run the access queries on other computers. I can copy the access,
excel, and text files to other computers. The other computers will be set up
to have the save directory structure under "My Documents".
How can I create a program that will re-establish the links to the excel and
text files on the new computers?
Note: The excel files all have column headers in the first row.