locked
Import Excel RRS feed

  • Question

  • User1788249541 posted

    Dear All,

     

     Im importing data Excel --> Sql server. In Excel filing having Export,Domestic data are "23.2" and "54.5". In Sql Server files as decimal(18,2),  While importing excel, I am getting conversion error.

    In Excel having varchar datatype.

    Im unable to change datatype in Excel sheet. Kindly do the needfull.

    Thanks and Regards,

    Jagadeesh V 

      

    Friday, July 8, 2016 9:44 AM

Answers

  • User1559292362 posted

    Hi vjagades,

    Im importing data Excel --> Sql server. In Excel filing having Export,Domestic data are "23.2" and "54.5". In Sql Server files as decimal(18,2),  While importing excel, I am getting conversion error.

    According to your description, I do a import action via the mothed the following link provide, it works well. please refer to the following link and check if it works for you.

    https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

    Best regards,

    Cole Wu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 11, 2016 5:38 AM