Share via

Numeric data is coming wrong while loading from excel to SQL TABLE using SSIS

siva rama krishna reddy tangirala 1 Reputation point
2020-10-09T15:44:43.513+00:00
  1. I loaded a column having values like 4.1, 3.6 from excel to SQL server table.
  2. Table column datatype is nvarchar(255) and in excel it is general.
  3. After loading into table, the values are like 4.0999346,3.051234.

How can fix this issue. I used IMEX=1 in connection manager.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,662 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Guoxiong 8,206 Reputation points
    2020-10-09T19:22:46.777+00:00

    Check if your excel "Format Cells ..." is set to 0.0. If yes, in excel 4.0999346 would be displayed as 4.1.

    0 comments
  2. CathyJi-MSFT 21,861 Reputation points Microsoft Vendor
    2020-10-12T08:38:08.287+00:00

    Hi @siva rama krishna reddy tangirala ,

    Any update for this thread? Did you check the format of excel as Guoxiong mentioned? If the response helped, do "Accept Answer". This can be beneficial to other Q&A members reading the thread.

    Best regards,
    Cathy

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.