Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - IMPORTING EXTERNAL DATA
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms excel training - IMPORTING EXTERNAL DATA
Resolved · Low Priority · Version Standard
Reply Thu 21 Jun 2007, 11:39Delegate Zoe said...
Zoe has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
IMPORTING EXTERNAL DATA
I have set up an XL sheet to import data from an MS Access database, which I have now moved from its original location. When I refresh the database, I get an error message that it can't find the access database. I click Ok and it takes me to a Login window where I select the Database tab and direct it to the database's new location. I click OK but when refreshing again, while I don't get an error message, the data don't change or the cells go blank. What should I do?
For upcoming training course dates see: Pricing & availability
RE: IMPORTING EXTERNAL DATA
Hi Zoe
The steps you have followed to re-connect sound correct. There are some troubleshooting things you may wish to try:
double check the data is correct in the database you are connecting to and that the file in the new location is the latest version
try connecting to the database from a fresh spreadsheet to make sure you can connect to the data - there may be a problem with your excel file.
I hope this helps - do let us know how you get on.
Kind regards,
Andrew
|
|