98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - IMPORTING EXTERNAL DATA
ms excel training - IMPORTING EXTERNAL DATA
Resolved · Low Priority · Version Standard
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?
Thu 12 Jul 2007, 16:36Trainer Andrew said...
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
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. |
Excel tip:Reset Excel toolbars to default settingsIf you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. |
