Hi,

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 & "#,...

Thank you.

This link should help explain what is going on:
http://allenbrowne.com/ser-36.html

HTH RuralGuy (RG for short) acXP WinXP Pro