Trouble importing date from CSV

[NickP]

Hi, I'm having trouble importing a date field directly into Access from a CSV file. The problem is that no matter how I play with the data import parameters, I get a type conversion failure.



If, on the other hand I open the file in Excel, import the field as a date field, manually format the values into the desired date format, then resave the CSV, I can import the date field into Access just fine.

Here is an snippet of how the data appears in the CSV file. Any help would be appreciated.

,2011-11-24 19:45:54.523000000,

Note - I did try manually deleting the decimal and trailing digits (e.g. .523000000) in the data above. That still didn't fix the problem.

[pdebaets]

Import it as a text field, then parse it into a date field in your table.

The CDate function may help.

Ex.:

currentdb.execute "Update MyTable set MyDateField = CDate(Left(MyDateImportTextField, 19));", dbseechanges + dbfailonerror