birju gohel

birju gohel

  • NA
  • 87
  • 39.6k

External table is not in the expected format. ASP.net C#

Feb 13 2015 2:35 AM
**

> Asp.net C# Code

**
I have one excel File 2013 Version Create And Excel File Data Insert Sql Server 2012 Table So Error
("External table is not in the expected format. in asp.net")

Excle File Image


Database Table Image
 
 
 

My Above Two Table And Colum
So iahve Trasfer Data Excel 2013 Version Filedata in sql Server 2012 Table .
 
 
My code

 
 
Please Any Solution Give me .

string excelConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", path);


External table is not in the expected format.


Answers (2)