I have a spreadsheet which gets data from an Access database. Both files were
created on a portable hard drive with drive letter H. I now have the files on
my local disk C and, of course, the spreadsheet can't find the data because
it is looking for drive H.

Is there an easy way to change the path to the target file so the
spreadsheet can find the Access file?

Well, the answer to that question depends on how the link was built:

1) If it's built via a macro in Access which dumps data into an Excel file,
you need to change the filepath in the Access macro.
2) If it's built via Excel's MS Query tool, you need to modify that query.

Post back with more information of the nature of the link and how it was
created and someone can be more specific.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"simonc" wrote:

I have a spreadsheet which gets data from an Access database. Both files were
created on a portable hard drive with drive letter H. I now have the files on
my local disk C and, of course, the spreadsheet can't find the data because
it is looking for drive H.

Is there an easy way to change the path to the target file so the
spreadsheet can find the Access file?

I used DataGet External DataNew Database Query and navigated to the Access
file.

"Dave F" wrote:

Well, the answer to that question depends on how the link was built:

1) If it's built via a macro in Access which dumps data into an Excel file,
you need to change the filepath in the Access macro.
2) If it's built via Excel's MS Query tool, you need to modify that query.

Post back with more information of the nature of the link and how it was
created and someone can be more specific.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"simonc" wrote:

I have a spreadsheet which gets data from an Access database. Both files were
created on a portable hard drive with drive letter H. I now have the files on
my local disk C and, of course, the spreadsheet can't find the data because
it is looking for drive H.

Is there an easy way to change the path to the target file so the
spreadsheet can find the Access file?