none
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.

     

    Thanks,

    Vinod Sa.

     

    Monday, August 6, 2007 2:48 PM

Answers

All replies