Not sure where to post this. I am trying to import my tables from ms access 2010 to my ms excel 2010 and doing this from excel. I have already did three other tables and they went great. The last one everything looked good the first time and went in. Then when I went to run it again, I got an error message.
Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.
I read on the internet about seeing if there were ERR? messages, and could not see any. Is there away to check the entire database to see if there are ERR??
The thing that does not make sense is that it worked great the first time, then stopped. I am trying to have the tables in excel so that after data is enter into access, the tables in excel will be automatically updated. I am using pivot charts so this is important to always have this updated data.
I sure hope that this is an easy fix.
Thank you in advance for you help.
Tony. :banghead::banghead:
Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.
I read on the internet about seeing if there were ERR? messages, and could not see any. Is there away to check the entire database to see if there are ERR??
The thing that does not make sense is that it worked great the first time, then stopped. I am trying to have the tables in excel so that after data is enter into access, the tables in excel will be automatically updated. I am using pivot charts so this is important to always have this updated data.
I sure hope that this is an easy fix.
Thank you in advance for you help.
Tony. :banghead::banghead: