Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    31

    Unanswered: Microsoft Access 2007 Error: Type Conversion Failure

    Hi All

    I have few columns on CSV file one of column header is ReviewDate when I import this csv file on Microsoft Access 2007 is giving an error:ReviewDate_ImportErrors
    All the data are imported successfully but only this column ReviewDate which appears to be blank on Microsoft Access database 2007. I had the same problems with other column on csv file with dates header but I converted dates i.e 10012013=10/02/2013 and all the row work but this particular column ReviewDate still giving an error .
    Any help will be appreciated.

    Error Log
    Type Conversion Failure
    ReviewDate_ImportErrors

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Dates are one of the things that can cause issues in SQL

    you'd be far better to use the ISO format (which is the SQL standard): yyyy-mm-dd.

    Theoreticaly the computer should use its localisation settings, and or Office localisation settings but sometimes it doesn't work
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2013
    Posts
    31
    Hi Healdem,

    Thanks very much I will try and reformat the dates and see what happens,

    Much appreciated

Posting Permissions

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