Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Unanswered: importing txt file, access cant convert a field to date

    I am importing a .txt file in delimited format. There are a couple fields that are dates in the format 010191, as in Jan 1, 1991. When I try to select Date/Time as the data type, I get "type conversion failure." Is there a way to convert this to date without use of VBA? My coding skills are very lacking... .

  2. #2
    Join Date
    Feb 2003
    I have tried this with an existing table and importing a new table and both work.
    The key I believe is that when you go thru the import wizard, select the advanced button and delete the / in the Date Delimiter and check the Leading Zeros in Dates.

Posting Permissions

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