Should have posted here.

I am attempting to query an Oracle db using MS Excel. I am using a datetime field to set criteria for a date range. It works fine when I use in Microsoft query, however when I reference a field in the spreadsheet it fails with a message that the numeric field is not right. How/can I reference a cell containing a date used as critera for the query?
Thanks,
Lee

Howdy. I think because when it comes back into Excel it is technically a text field, not a date field (I could be wrong, so am open to correction).