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:
SELECT pivot.Company, pivot.Code, pivot.Caption, pivot.Compte, pivot.`Libellé compte`, pivot.SumOfNet
FROM...