mrl

You need a parameter query. See here

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

and here

http://www.dicks-blog.com/archives/2...-data-queries/

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

mrl wrote:
How does one create a dynamic SQL query then? I.e. I need to take
data from the spread sheet, such as an account number and date, and
use that in the SQL query. Thanks.

JE McGimpsey wrote:
No. Use Microsoft Query to run a query from the worksheet instead.

In article , mrl
wrote:
Does SQL.REQUEST work in Excel X under OSX? Thanks.