PC Review


Reply
Thread Tools Rate Thread

Expected Date/Time Format During Table Import

 
 
Don
Guest
Posts: n/a
 
      28th Sep 2005
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


 
Reply With Quote
 
 
 
 
Don
Guest
Posts: n/a
 
      28th Sep 2005
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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't import Paradox 5 tables - "...not in the expected format" GovDev Microsoft Access 4 3rd Oct 2008 06:43 PM
Paradox import error 'not in expected format' Andrew Brill Microsoft Access External Data 0 7th Feb 2006 02:42 PM
Expected Date/Time Format During Table Import Don Microsoft Access External Data 1 28th Sep 2005 05:28 PM
[Microsoft][ODBC Paradox Driver] External table is not in the expected format. viki Windows XP Drivers 0 17th Jun 2004 01:24 PM
ADO - Excel - External table is not in the expected format Adriana Camargo Microsoft Excel Programming 3 21st May 2004 01:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:57 AM.