How to use Excel sheet from office 2007 RRS feed

  • Question

  • Hi,


     I could use Excelsheet from office 2003(Whose extension is .xls),but I could not use excelsheet from office 2007 (Whose extension is .xlsx)


    following is the exception,


    Additional information: External table is not in the expected format.


    I have used connection string as follows,


    objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +

    "Data Source=" + "C:\\City.xlsx" + ";" +

    "Extended Properties=" + (char)34 +

    "Excel 8.0;HDR=Yes;" + (char)34;


    What would be solution for it...

    Anybody could help me,It is very urgent.


    Any kind of help would be appreciated.



    Vinod Sa.


    Monday, August 6, 2007 2:48 PM


All replies