Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Western part of Georgia, USA

    Unanswered: Date field and Oracle criteria

    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?

  2. #2
    Join Date
    Oct 2003
    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).
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts