software

Hi,

I have setup an Access database which holds tables of information I need to
present in Excel. I have setup an 'Import External Data' Access Query, which
works fine and pulls through fresh data when I refresh the query, however I
moved the source file to another location and it can't find it.

Is there a way I can change this, I have 12 worksheets linking to different
tables in this database and am slightly reluctant to set them up again if I
don't need to.

Thanks for any help...Try this:

Put a copy of the Access database back in its original location

In your workbook, edit the query (Datagt;Import External Datagt;Edit Query)
From the query window, click the [SQL] button.
-The SQL code should display the location of the Access file.
--gt;Change it to the new location
Then, return the data.

Last step: Delete the copy of the MDB file

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Louisequot; wrote:

gt; Hi,
gt;
gt; I have setup an Access database which holds tables of information I need to
gt; present in Excel. I have setup an 'Import External Data' Access Query, which
gt; works fine and pulls through fresh data when I refresh the query, however I
gt; moved the source file to another location and it can't find it.
gt;
gt; Is there a way I can change this, I have 12 worksheets linking to different
gt; tables in this database and am slightly reluctant to set them up again if I
gt; don't need to.
gt;
gt; Thanks for any help...
gt;

Excellent - THANK YOU - it worked perfectly!

Kind Rgds,
Louise

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Put a copy of the Access database back in its original location
gt;
gt; In your workbook, edit the query (Datagt;Import External Datagt;Edit Query)
gt; From the query window, click the [SQL] button.
gt; -The SQL code should display the location of the Access file.
gt; --gt;Change it to the new location
gt; Then, return the data.
gt;
gt; Last step: Delete the copy of the MDB file
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Louisequot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have setup an Access database which holds tables of information I need to
gt; gt; present in Excel. I have setup an 'Import External Data' Access Query, which
gt; gt; works fine and pulls through fresh data when I refresh the query, however I
gt; gt; moved the source file to another location and it can't find it.
gt; gt;
gt; gt; Is there a way I can change this, I have 12 worksheets linking to different
gt; gt; tables in this database and am slightly reluctant to set them up again if I
gt; gt; don't need to.
gt; gt;
gt; gt; Thanks for any help...
gt; gt;

Thanks for the feedback...I'm glad I could help.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Louisequot; wrote:

gt; Excellent - THANK YOU - it worked perfectly!
gt;
gt; Kind Rgds,
gt; Louise
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; Put a copy of the Access database back in its original location
gt; gt;
gt; gt; In your workbook, edit the query (Datagt;Import External Datagt;Edit Query)
gt; gt; From the query window, click the [SQL] button.
gt; gt; -The SQL code should display the location of the Access file.
gt; gt; --gt;Change it to the new location
gt; gt; Then, return the data.
gt; gt;
gt; gt; Last step: Delete the copy of the MDB file
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Louisequot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I have setup an Access database which holds tables of information I need to
gt; gt; gt; present in Excel. I have setup an 'Import External Data' Access Query, which
gt; gt; gt; works fine and pulls through fresh data when I refresh the query, however I
gt; gt; gt; moved the source file to another location and it can't find it.
gt; gt; gt;
gt; gt; gt; Is there a way I can change this, I have 12 worksheets linking to different
gt; gt; gt; tables in this database and am slightly reluctant to set them up again if I
gt; gt; gt; don't need to.
gt; gt; gt;
gt; gt; gt; Thanks for any help...
gt; gt; gt;