syntax error in from clausule

  • Thread starter Diederik Nieuwenhuis
  • Start date
D

Diederik Nieuwenhuis

I want to create a query based on a ODBC connection to a
Ms-Access file. This file has tables linked via a Oracle
SQL ODBC driver. I open the .mdb file by selecting (within
Excel), Menu data, Menu Import external data, New database
query and then select the MS-Access ODBC driver.

Then I do have to possibility to open the Access file
within Excel and select the columns I want to see but at
the end the message "syntax error in from clausule"
appears.
This the query created by Microsoft Query.

SELECT `300-Finding`.DATESUBMIT
FROM `E:\70`.`Configuration mgt\70`.`40 TMT-
Database\TMT_2000`.`300-Finding` `300-Finding`

Hope somebody can help me

Diederik
 
Top