Excel (xlsx) DB and date/time
Posted: Sat Sep 26, 2015 11:48 am
I have attached an Excel file (xlsx) as a database and I'm trying to set up the SELECT statement to pull the appropriate data.
The Excel has one column for DATE and a separate one for TIME. The formats are mm/dd/yyyy and hh:mm:ss am/pm.
When I hit refresh to display the result, it shows the DATE as mm/dd/yyyy hh:mm:ss am/pm and the TIME column sows the following:
Error: date out of range!
Everything looks fine on the Excel file. Any ideas why this error appears?
The Excel has one column for DATE and a separate one for TIME. The formats are mm/dd/yyyy and hh:mm:ss am/pm.
When I hit refresh to display the result, it shows the DATE as mm/dd/yyyy hh:mm:ss am/pm and the TIME column sows the following:
Error: date out of range!
Everything looks fine on the Excel file. Any ideas why this error appears?