Microsoft Query

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

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

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