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

Question

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.

Answer 1

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

Answer 2

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