Hi M_shah

You could try to change the registry entry for the driver you are using, by default it is set to 8. Make it a bigger amount like 1000. I'm using the following with in Yukon to import data to sql. ( this needs to happen on the Server not your machine ) "TypeGuessRows" is the key value you need to change

SELECT *

INTO #TempTable

FROM OPENROWSET ('Microsoft.Jet.OleDB.4.0', 'Excel 8.0;HDR=YES;IMEX=1;Database=C:\HelloWorld.xls;User ID=;Password=;','SELECT * FROM [Sheet1$A2:E10000]');

HDR = Yes just means 1st row is the header row

IMEX = 1 Is the default

Windows Registry Editor Version 5.00

*********REGISTRY STUFFF**********

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel]

"win32"="C:\\Program Files\\Microsoft Office\\OFFICE11\\msaexp30.dll"

"DisabledExtensions"="!xls"

"ImportMixedTypes"="Text"

"FirstRowHasNames"=hex:01

"AppendBlankRows"=dword:00000001

"TypeGuessRows"=dword:00000000

"win32old"="C:\\WINDOWS\\System32\\msexcl40.dll"