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

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






"Don" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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
>