Manoj Kumar Goud
10/13/2006 3:48:00 AM
Hi Paul,
thanks for giving some tips.I also used IMEX=1 but no result.Please see my
string what I used in my program.
private const string EXCEL_CONNECTION_STRING_1 =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
private const string EXCEL_CONNECTION_STRING_2 = ";Extended
Properties=\"Excel 8.0;;HDR=No;MaxScanRows=0;IMEX=1\"";
Is there any other changes in this string
Regards,
Manoj
"Paul Clement" wrote:
> On Wed, 11 Oct 2006 23:06:02 -0700, Manoj Kumar Goud <Manoj Kumar Goud@discussions.microsoft.com>
> wrote:
>
> ¤ when i imported excel sheet to datagrid some of values are ignored.If i
> ¤ change the TypeGuessRows registry key value in path
> ¤ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines to 0 then its working
> ¤ fine .But it is not the right way to change the registry key.So I followed
> ¤ alternative way.I used MaxScanRows in my source code .But it has no
> ¤ effect.Can anyone please help me about this problem.Is there any way how to
> ¤ use MaxScanRows property, so that it will work fine.I tried in different way
> ¤ like MaxScanRows=0/MaxScanRows=FFFFFFFF but no effect.Please help me out so
> ¤ that I ll be glad to u.
>
> Try specifying the IMEX argument:
>
> ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
> "Data Source=e:\\My Documents\\Book2.xls;" +
> "Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;IMEX=1;" + (char)34;
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>