Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004

    Unanswered: Importing a date field in Access table( from file)

    Hi ,

    Iam trying to import data from a text file .The data is shown below

    TXPA01|20080601|Account number was not found.|5

    MS Access is not able to import the 2 nd column into field of type datetime.Is there any way to change the format to mm\dd\yyyy to import the data?


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    How are you importing the data?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    well you could import the data into a temporary table storing the date as a text field then run an insert query reformatting the date as required.

    Im surprised that Access can't handle the ISO date though, I woul dhave expected it to handle that.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Feb 2004
    Chicago, IL
    I got it to work. When you link or import the wizard that appears has the Advanced button on it. When you hit that you will be able to change the format of the dates that Access is looking for. The default is MDY. I changed it to YMD and I removed the / as the date delimiter, then I made sure the date field was being defined as a DateTime field and when I linked it it worked for me. (Access 2002)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts