Pivot Tables: Syntax Error in From Clause

[bp]

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

 

[bp]

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...