excel datasource error

See more:

C#3.0

C#

I am trying to connect Excel 2010 .xslm thru below connection string: -

string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;
               Data Source=F:\Project Chunauti\OCCL Mundra Dashboard U1.xlsm;Extended Properties=""Excel 12.0 Macro;\""";

It works only when the mentioned file is opened in excel. But for .xlsx file it works.

Query result also gone very slow to fill C# datagridview.

When this file is not opened, it gives an error "External table is not in the expected format."

Any idea please.

--- Thanks.
--- Anil