Syntax Error in FROM clause

[AUcane]

I have a very simple query set up in my database that merely selects employees from a master list that fall under a certain parameter.

I am trying to incorporate this query into Excel via the Import External Data>New Database Query and using a SQL query designed to create the refreshable data. When I try to view the data in the MS SQL Query mode, i get error message "Syntax Error in From Clause", and i am not able to view the data.

Any thoughts?

 

[dk]

Hi,

Are you able to view the SQL statement? We'll need to see that to be able to fix your problem.

 

[AUcane]

Here's the SQL statement:

SELECT `_EMPLOYEE QUERY`.last, `_EMPLOYEE QUERY`.first
FROM `I:\databases 7`.`5\aSCII Interfaces\Allocations`.`_EMPLOYEE QUERY` `_EMPLOYEE QUERY`


"last" and "first" are the two fields of the access query.