Pass date parameter into MS Query
 

All,

I have achieved this before but cannot for the life of me rememeber how...

I have an Oracle database and build my query in MS Query. At the moment I
hard code the date criteria.

How to I pass this parameter from an Excel cell?

Thank you.

Richard

Pass date parameter into MS Query
 

On Jun 20, 3:30*pm, "Richard Edwards" wrote:
All,

I have achieved this before but cannot for the life of me rememeber how....

I have an Oracle database and build my query in MS Query. At the moment I
hard code the date criteria.

How to I pass this parameter from an Excel cell?

Thank you.

Richard

chk out http://www.mrexcel.com/archive2/19400/22013.htm

Pass date parameter into MS Query
 

you beauty. thanks vm.


"Nayab" wrote in message
...
On Jun 20, 3:30 pm, "Richard Edwards" wrote:
All,

I have achieved this before but cannot for the life of me rememeber how...

I have an Oracle database and build my query in MS Query. At the moment I
hard code the date criteria.

How to I pass this parameter from an Excel cell?

Thank you.

Richard

chk out http://www.mrexcel.com/archive2/19400/22013.htm