var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SSIS Import of Excel data like "9760020" imports "9.76002e+006"
I have a problem with the Import of an Excel file with SSIS and hope one of you can help me out.
There is a column with mixed data (format is TEXT) in an excel file and I want to import it as Text (DT_WSTR (255)).
So far everything works fine but some fields like "9760020" imports "9.76002e+006".
My settings so far are:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<FileName>;Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1"
In addition I altered the registry entry from Microsoft.Jet.engine.excel
TypeGuessRows to 0 (ImportMixedType = Text)
Has someone got a solution?
9760020 = 9.76002e+006
So SSIS is not doing anything wrong.
This is clearly a number and should be treated as one. Numbers <> text.
no its not a number....
my settings from the first post (IMEX=1) say treat everything as text....
Yes I realise that - but that is where the issue is stemming from!
The number is being converted into text!
Yeah indeed, change the format of the column to number = problem fixed
Originally Posted by georgev
no I have mixed data like
I have the same problem before. SQL Server cannot do anything. Before loading, convert data type from General to Nemuric in Excel.
It doesn't matter, just change it to number column in excel as I and others have already said and it will fix your problem....
Originally Posted by -JWS-