Microsoft Query
 

I'm trying to use Microsoft Query with Excel worksheets.
"tCustomers" is defined in the workbook.

When I insert this sql statement

SELECT tCustomers.FirstName, tCustomers.LastName
FROM `C:\Documents and Settings\whoever`.`PMANT1\My
Documents\Data`.tCustomers tCustomers

I get the following...

Syntax error in From clause

just a guess... it looks like your single quotes are strange... should you
have '.' between whoever and PMANT1?

"VNCNTJ" wrote:

I'm trying to use Microsoft Query with Excel worksheets.
"tCustomers" is defined in the workbook.

When I insert this sql statement

SELECT tCustomers.FirstName, tCustomers.LastName
FROM `C:\Documents and Settings\whoever`.`PMANT1\My
Documents\Data`.tCustomers tCustomers

I get the following...

Syntax error in From clause