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