connection string to write for importing mixed data from excel sheet

[shanmugaraj.ind]

What is the connection string to write for importing mixed data from excel sheet to data
grid

My problem is, I have rows like

1

2

3

4

5

6

7

8

9

a

b

c

d

in excel sheet.But when I imported these rows only 1-9 imported succesfully but a-d ignored. I used IMEX=1,MaxScanRows=0 in Extended property. but no effect.Can u plz help me about this issue if u have any other idea with out changing the value of TypeGuessRows registry key from 8 to 0.

Before I have change registry MaxScanRows=0 that is not working

connection string I have used below

xls
con = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + _strFullPath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
con = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _strFullPath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX =1;\"";

csv
con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _serverPath + ";Extended Properties=\"text;HDR=YES;FMT=Delimited\"";

There is no change upgrade the Microsoft.ACE.OLEDB.12.0 It return same output

Connection string have no changes as it i used

If we check with dataset some value not present dataset

Any one know the solution.

I want as its in the excel