none
The value could not be converted because of a potential loss of data

    Question

  • During import from CSV i am getting following error "The value could not be converted because of a potential loss of data". My CSV file contains a column "years" and i have selected datatime in the import wizar. Can I scape from this error and import all my data.

    Waqar

    Tuesday, May 30, 2006 11:04 AM

All replies

  • You are probably attempting to do a conversion on a value that cannot be implicitly converted. Use the error output to find out what the value is.

    Once you have identified the offending value you can import that column as a string and do the conversion to datetime.

    One question, what value does the "years" column contain?

    -Jamie

     

    Tuesday, May 30, 2006 11:32 AM
    Moderator