Importing Date Field into Access

[Amileaux]

We download a text file from a web site. It contains a date field with a #YYYY-MM-DD# format. Excel converts this appropriately. However, I would like to import this directly into access without stopping at Excel. This date field refuses to come across (my import specification makes it a date field). Upon researching this a little, it appears that Access only likes date in the #mm/dd/yyyy# format.

My proposed work around is to import this field as a text field, then write a query to convert it (using datepart I think) to a date and then load it to the final table.

Any thoughts on an easier more direct solution? Marie

 

[Russell Hauf]

In your import specification, try changing "Date Order" to YMD.

HTH,

Russell

 

[Amileaux]

Thank you!!! It worked. Feel rather stupid - never noticed that before. Marie