I will post the code when I get to my work pc I need the sql code to look at
the excel sheet for the date and do not know how to write that code or if
that can be done. The sheet if for several people that do not know sql and I
can not have them changing the code. Still doable or not. Will post code on
a bit. Thanks for the reply.

"FSt1" wrote:

hi,
yes it can be done. what method are you using? post your code.
in your SQL statement you will need to add a where clauseafter the select...
where datefield = [what date?]

regards
FSt1

"Traci" wrote:

I am trying to add a prompt for a date to make my external data pull from a
certain date only does anybody know how to do this. I am pulling from a SQL
Database and have to have a date prompt or I exceed the row limits set in
excel. I don't think it can be done but wanted to ask anyway. Thanks for
the help.