Download excel sheet problem

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

Answer 1

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