How to extract a value from Excel and include it in a query
 

wsimko

Check here

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

Near the bottom it explains about parameter queries

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"wsimko" wrote in message
...
How could i use microsoft query to extract a value from Excel and include
it
in a query?

The following is an excerpt of the microsoft query. I would like the
dates
to be read rather than manually updated.
Thank you

(PTSLS.DateInvoice={ts '2006-12-01 00:00:00'} And PTSLS.DateInvoice<={ts
'2006-12-31 00:00:00'})

--
wsimko