HI.. When i have given Excel file path as a varaible, then the column names in the first row is got unchecked and even if i check again its not taking. But with out varaible it worked properly. Please help me whrere i am going wrong. Thanks Venu

For quick assistance, can you post your code? Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 Grand Slam

For quick assistance, can you post your code? Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 Grand Slam

Hi Kalman, I figured out what is the error previiously i am using this as HDR=NO"; Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NounCode\SourceFiles\Noun Code List for SBS.xls;Extended Properties="EXCEL 8.0;HDR=YES";