| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Data using Web query | Excel Programming | |||
| Excel Query fails to include data? | Excel Programming | |||
| Data extract from access query | Excel Discussion (Misc queries) | |||
| Need help! - Trying to use MS Query in Excel to extract MS Access | Excel Discussion (Misc queries) | |||
| Using Microsoft Query to Extract Data | Excel Programming | |||
Linear Mode
