I'm trying to query data from MS access in excel 2003 and access 2003.
I go through the Query tool wizard and inevitably get the Syntax error in FROM clause. Here's my super simple SQL:
I can't imagine the "FROM" stuff is accurate from the wizard, but there is no sample syntax anywhere in the entire web (or at least the first five googled pages.)
If anyone knows how to help, the access file is:
C:\Documents and Settings\HP_Owner\Desktop\France\2007.mdb
The table is called pivot
and I want to make a pivot table in excel out of it
Thanks
I go through the Query tool wizard and inevitably get the Syntax error in FROM clause. Here's my super simple SQL:
Code:
SELECT pivot.Company, pivot.Code, pivot.Caption, pivot.Compte, pivot.`Libellé compte`, pivot.SumOfNet
FROM `C:\Documents and Settings\HP_Owner\Desktop\France\2007`.pivot pivot
If anyone knows how to help, the access file is:
C:\Documents and Settings\HP_Owner\Desktop\France\2007.mdb
The table is called pivot
and I want to make a pivot table in excel out of it
Thanks