P
Preston
Hi,
I have a problem with trying to connect to an access db. I have Office 2007
installed and running on machines in my office and have put together a split
database in the accdb format. The only problem is that I have one machine
that I need to have show a pivot table from the backend tables in Excel 2003.
I created and tested the Excel file without any problems in Excel 2007 and
have had no trouble getting it to connect to the accdb database backend.
However, when i run the file in xls format in Excel 2003 it can't connect.
Not only can it not connect, it can't see accdb files to add a connection.
How can i get the data from the accdb file into the pivot table in excel
2003? Thank you in advance for your help.
Preston
I have a problem with trying to connect to an access db. I have Office 2007
installed and running on machines in my office and have put together a split
database in the accdb format. The only problem is that I have one machine
that I need to have show a pivot table from the backend tables in Excel 2003.
I created and tested the Excel file without any problems in Excel 2007 and
have had no trouble getting it to connect to the accdb database backend.
However, when i run the file in xls format in Excel 2003 it can't connect.
Not only can it not connect, it can't see accdb files to add a connection.
How can i get the data from the accdb file into the pivot table in excel
2003? Thank you in advance for your help.
Preston