Access query to pivot table in Excel

  • Thread starter Thread starter massa
  • Start date Start date
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!!!
 
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
 
Back
Top