Pivot Tables: Syntax Error in From Clause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using an access database as an external data source for a pivot table.
The access table is linked to a semi-colon delimited text file. After
completing the wizard with the following parameters, I get the error "Syntax
Error in FROM clause"

- select all columns in the table
- no filter criteria
- no sort criteria
- return data to Microsoft Office Excel
 
Figured it out - The table name was called pivot and this must be some type
of keyword because once I changed the name, everything worked fine...
 
Back
Top