Last post Oct 12, 2008 06:20 AM by PaulSpencer
Oct 10, 2008 11:41 AM|hemal2801|LINK
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
Oct 12, 2008 06:20 AM|PaulSpencer|LINK
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