Excel to Access - Date gets reversed
I'm storing data from Excel into Access (both 2k3)... but the day & month values are getting reversed if the day is less then 13...
For example... in excel, I have a cell that has 11/04/2008 (entered as Ctrl + ;), and in Access when I format the cell as dd/mmmm/yyyy it comes out as 11/November/2008
Any suggestions on how to get around this... makes it very difficult to later do queries based on dates when everything is backwards...
Also, I'm inserting the data as so:
Dim order_commit_dt As Date
order_commit_dt = Range("A" & curRow).Value
VALUES (#" & order_commit_dt & "#,...