Ads Top

Connection string to connect Excel file with c#

 public static string MakeExcelConnectionString(string dataSource)
        {           
 _connectionString = $@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={dataSource};Extended Properties=""Excel 12.0 Xml;HDR=YES""";
return _connectionString;
        }
Powered by Blogger.