Expected Date/Time Format During Table Import

[Don]

I am trying to create a table by importing CSV data from a text file. There
is a time stamp field in the CSV file. A typical value looks like:

9/28/2005 9:00:36 AM

When importing the CSV file, the import filed is changed from 'Text' to
'Date/Time'. But when the import is processed, MS Access reports 'type
conversion errors'. The time stamp field in the CSV file is generated by
printing the value of a Date/Time variable in a VB application. It would
seem the two should be compatible.

Any ideas on how to address this problem will be greatly appreciated!

Thanks!

Don

 

[Don]

Problem solved!

Through experimentation, concluded that the imported date/time must be in
24-hour format:

9/28/2005 9:00:36 not 9/28/2005 9:00:36 AM
9/28/2005 21:00:36 not 9/28/2005 9:00:36 PM

Hope this saves someone a similar adventure!

Don