Access query to pivot table in Excel

M

massa

I have a query in which I want to create a pivot table in excel. When I try
to open the db in excel I receive an error Syntax Error [missing operator]
Query 2.1998.Doc Type
After looking at the SQL coding I wrote in access there seems to be no error
with that field and I was able to run the query. Is there some setting in
excel that I am missing?
Please help!!!
 
J

Jeanette Cunningham

massa,
how are you opening the db in excel?
Are you using Data | Import Extenal Data which allows you to link to the
access query that supplies the data for the pivot table?


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

Similar Threads

Access #Error & Excel Pivot 0
Pivot Table 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Pivot using 250,000 rows of data in Excel? 1
Error Exporting Access Query Results to Excel 1
Alex Dybenko: Create Pivot Table in Excel using automation? 3
pivoting query 1
Displaying custom ribbon with Pivot table 2

Top