Comments by bineet dungdung

bineet dungdung 7-Mar-13 7:00am View

This is the code i used

string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sourceFile_MP + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

bineet dungdung 6-Mar-13 15:55pm View

I have asked it as question . Thank you for reminding me. The question subject is IMEX = 1, HDR = No still does help reading excel file with mixed data formats ?

bineet dungdung 6-Mar-13 15:42pm View

Hi,i am reading an Excel source file having mixed data formats and there are many rows which are generated through calculations in the sheet. I applied the IMEX=1 and HDR = No,It didnt solve the purpose .Further I also changed the TYPEGUESSROWS key from 8 to 0 and the ImportMixedTypes to Text in the registry location HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel .
It still does not read after 160 rows.
Please Help me on this .

Comments by bineet dungdung (Top 3 by date)