Thread: Microsoft Query
View Single Post
  #1   Report Post  
VNCNTJ
 
Posts: n/a
Default 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