Ted

WHERE SALE_DATE=?

The question mark is a place holder for the parameter. If you put the
question mark in there, it will default to a prompt-type parameter. You can
change that to cell ref-type parameter in Excel. See here

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"TedGrier" wrote in message
...
From Excel, I need a data query to use the value of a
cell. It should read something like this:

SELECT Count(*) FROM Orders WHERE SALE_DATE='Sheet1'!B5

I cannot get the query to read anthing from the Excel
sheet.

Isn't there an obvious way to do this????

Thanks!!!!