Hi Guys., How to get the A1 column data? i have read 2 set of values same in the excel document., Example query for excel file reading., SELECT * FROM [Sheet1$A1:A2],[Sheet2$A5:G100] it's working fine but value is "NULL" please sugget some query to fetch the first column value(A1) in excel file ThanksRanganathan.Palanisamy

Hi, Change the COLUMN Type Property to nVARCHAR.. Try this !! Regards, Guru

thanks for Reply My question is how to read the A1 column as a value.,As well as A3 to B200 Column ThanksRanganathan.Palanisamy

I am not sure. In Excel source --> data access mode try with table name or view name variable and use variable.

check this link. not sure if this solves ur issue. http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx