Download excel sheet problem RRS feed

  • Question

  • User-1758450890 posted


    Hi Experts,

    I just want to tell you that i had a problem at the time of import excel file.

    Programme is in ASP.NET and C#.NET

    I have one grid view which bind at design time and two combo box on the grid in Row temp let.

    I have download excel file without this two combo box.

    but column header has different name at design time like (01,02,03,......) and Column has different name in Table format in DB like (Col 1,Col 2,.......)

    Excel sheet download with 01 column name.

    I am using Ole Db connection object to Make connection and import excel data to SQL database.

     but at the time of connection it gives below error.

    when i want to import this file it gives error like (External table format is not valid)

    Please help me out

    Friday, October 10, 2008 11:41 AM

All replies

  • User608358548 posted

    are you sure that's the exact error, as I cannot find it anywhere.  are you sure it wasn't:External table is not in the expected format


    Sunday, October 12, 2008 6:20 AM