Windows 7 64 Bit Excel query error


A

Al

I have an Excel 2007 pivot table with data that resides in Access 2007. In a
32 Bit environment the pivot table refreshes without error.

I installed Win 7 64 bit and office 2010 64 bit. I try to refresh data, but
get an error. "The query did not run, or the database table could not be
opened."
I uninstalled Office 2010 and installed 2007. However the problem persist.
I'm assuming it's an issue with 64 Bit of Windows 7. Thanks in advance for
your help.
 
Ad

Advertisements

A

Al

Resolved with Excel 2007.

My ODBC connection was not working properly. Although i had created an ODBC
connection, when i tried to link another table through "SQL" in Access it
would work. I looked at my connections and noticed there wasn't one. So i
recreated it and everything works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top