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

Doughnut Chart linked with the slicer in the pivot table 0
Dates In Excel 5
Append Crosstab Query to Existing Table 0
Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
How to display zero value in blank fields of Cross Tab query 0
Pivot Table cell values 1
Integrating information from Word to Excel (not mail merge) 1

Top