External table is not in the expected format in c#

Asked Jan 21 '16 at 08:59

Active Jan 22 '16 at 10:07

Viewed 640 times

I am trying to work with .xlsx file with the below Connection string in my C# code .

public static string ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;
   Data Source=@@filename;
   Extended Properties=""Excel 12.0 Xml;
   IMEX=0;
   HDR=YES;
   TypeGuessRows=0;
   ImportMixedTypes=Text""";

But whenever I am running the Code I am getting Error

System.Data.OleDb.OleDbException (0x80004005): External table is not in the expected format.

edited Jan 22 '16 at 10:07

asked Jan 21 '16 at 08:59

himanshu jain

Running _what_ code? – Tim Schmelter Jan 21 '16 at 09:00
its C# code for xlsx files. – himanshu jain Jan 21 '16 at 09:09
http://stackoverflow.com/q/1139390/447156? – Soner Gönül Jan 21 '16 at 09:14
not able to find any solution from above link ...:( – himanshu jain Jan 21 '16 at 09:32

External table is not in the expected format in c#

0 Answers0