JVFriederick
IS-IT--Management
I've been using Excel and the "MS ODBC for Oracle" driver to query Oracle and Access tables.
When I use parameters, I can point to specific cells in the spreadsheet to pass those values along to the query. (which is easier to change compared to bringing up MSQuery each time)
When pointing to an Access table, I can set up strings, wildcard strings, numbers, and dates as parameters.
So far, life was good.
When pointing to an Oracle table, I can set up strings, wildcard strings, and numbers as parameters - but not dates. I've tried many combinations of date formats but with no success.
I've also tried the "special" Oracle drivers (which don't pass dates for me either). For company wide compatability reasons I would prefer to find a solution with the "MS ODBC driver for Oracle" or something similar.
My question - how can I pass a date parameter from a spreadsheet cell to the ODBC driver while pointing to an Oracle database ?
When I use parameters, I can point to specific cells in the spreadsheet to pass those values along to the query. (which is easier to change compared to bringing up MSQuery each time)
When pointing to an Access table, I can set up strings, wildcard strings, numbers, and dates as parameters.
So far, life was good.
When pointing to an Oracle table, I can set up strings, wildcard strings, and numbers as parameters - but not dates. I've tried many combinations of date formats but with no success.
I've also tried the "special" Oracle drivers (which don't pass dates for me either). For company wide compatability reasons I would prefer to find a solution with the "MS ODBC driver for Oracle" or something similar.
My question - how can I pass a date parameter from a spreadsheet cell to the ODBC driver while pointing to an Oracle database ?