When attempting to Query an oracle Database using Excel 2013 64 bit and 32 bit I receive the following error:
oracle odbc ora ora-01843 not a valid month
In Excel 2010 we could correct this issue by formatting the date cell as text. This no longer works in Excel 2013
Better to format the query to match the data in the cell.
You normally do this using TO_DATE in the select.
Example to_date ('01/01/2001','MM/DD/YYYY'
If you can provide what the data looks like in the cell and the query you are executing, we can probably help you out.