SQL Server Performance

Data Type Conversion Problem

Discussion in 'SQL Server DTS-Related Questions' started by danny123, Aug 2, 2006.

  1. danny123 New Member

    Hi
    i am using dts service to import data from excel sheet to the db table.
    but it gives conversion prob like
    Source is using DBType_R8 and desination DBType_NUMERIC :conversion not possible
    please help.
    Best
    Danny
    danny123, Aug 2, 2006
    #2

  2. Adriaan New Member

    Excel is about the worst sort of data source - by definition, everything is free-text. Sometimes, if you're lucky, someone has been very careful. But they don't always have the same default formats that you might be expecting.

    So take a close look at what data you're receiving.
    Adriaan, Aug 2, 2006
    #2

Share This Page