Expected Date/Time Format During Table Import

Discussion in 'Microsoft Access External Data' started by Don, Sep 28, 2005.

  1. Don

    Don Guest

    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, Sep 28, 2005
    #1
    1. Advertisements

  2. Don

    Don Guest

    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" <> wrote in message
    news:%...
    >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, Sep 28, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris B

    Re: "External table is not in the expected format"

    Chris B, Jul 14, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    11,179
    Joe Fallon
    Jul 15, 2003
  2. Hunter

    linking error (external table not in expected format)

    Hunter, Jan 22, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    402
    Hunter
    Jan 22, 2004
  3. Tamer

    Error: External table is not in the expected format

    Tamer, Feb 20, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    488
    Tamer
    Feb 20, 2004
  4. DC

    "External table is not in the expected format"

    DC, Mar 12, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    581
  5. Andrew Brill

    Paradox import error 'not in expected format'

    Andrew Brill, Feb 7, 2006, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    1,853
    Andrew Brill
    Feb 7, 2006
Loading...

Share This Page