Is there a ' (single quote) in front of the values (seen in the formula bar)? How do the data look like?Arthur My Blog

Hi All, I have question regarding reading excel file through excel adapter....When I am reading .xls file thru excel adapter ....for one column its intrepreting the data as null....But when I check in my original .xls file ...the data is showing up ...but when I am reading thru excel adapter its considering it as null...every field its taking it as null....tried various ways like save as ...and formatting to text and number etc....but it doesnot help either...CAn any one suggest me how to acheive this....appreciate ur responsesvineesh1701

No...there is no single quotes.... The data has some values 100809,100709,1004567...like this...thats itvineesh1701

Good, then use IMEX=1 setting in your data source's connection string. This will make all treated as strings. And then you may need to use Data Conversion in Derived Column Transformation.Arthur My Blog

Does your sheet have hidden rows, or some rows in that column that have text values? Excel doesn't understand data types - formatting data is just formatting, it's not changing, setting, or enforcing a data type. When the Excel Connection Manager reads a sheet, it "guesses" at what data type the column contains. It isn't always right, and when it runs into data that can't fit in the type it's chosen, it reads the value as NULL. You should probably read Douglas Laudenschlager's series of posts on Excel for more information on workarounds. Talk to me now on

Ya ...It contains hidden property checked.....vineesh1701

I don't understand your comment. What's a hidden property? I asked if your spreadsheet had rows hidden in it. Talk to me now on

HI , I am sorry for the confusion....When I right click the cell/column ....and then selected Format Cells ...there is one tab called protection....In that locked property is checked in.....So i am thinking whether this is causing excel adapter to read the entire column values as null...? vineesh1701

No - cell protection isn't relevant. Can you post a sample of the spreadsheet somewhere? Without sensitive data? Talk to me now on