Microsoft Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Query to Linq (Group By and Sum) 6
displaying other data from other tables 3
NewRowBuilder 1
Using external query (mdb) for dynamic date range 2
Calling Parameterized Query Using SQL Syntax 3
Populating multiple combo boxes 5
Beginner Problems 7
Excel Appending data from Excel 2007 to Access the joys of VBA 0

Back
Top