Null values in excel problem

Null values in excel problem

The connection string should look like

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Sample\SampleExcelFile.xls;Extended Properties="EXCEL 8.0;HDR=Yes; IMEX=1;"

or

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Sample\SampleExcelFile.xls;Extended Properties="EXCEL 8.0;HDR=Yes; IMEX=1;"

IMEX = ImportMixedTypes

http://dougbert.com/blogs/dougbert/archive/2009/11/21/importing-from-excel-imex-and-mixed-data-types.aspx

http://dougbert.com/blogs/dougbert/archive/2008/06/21/excel-in-integration-services-part-3-of-3-issues-and-alternatives.aspx