public static string GetConnectionString(OledDbDriverName driverName, ExtendedProperties extenProps, string filePath)
{
Dictionary <string, string> props = new Dictionary <string, string>();
// XLSX - Excel 2007, 2010, 2012, 2013
props["Provider"] = GetDriverName(driverName);
props["Extended Properties"] = extenProps.GetStringValue();
props["Data Source"] = filePath;
// XLS - Excel 2003 and Older
//props["Provider"] = "Microsoft.Jet.OLEDB.4.0";
//props["Extended Properties"] = "Excel 8.0";
//props["Data Source"] = "C:\\MyExcel.xls";
StringBuilder sb = new StringBuilder();
foreach (KeyValuePair <string, string> prop in props)
{
sb.Append(prop.Key);
sb.Append('=');
sb.Append(prop.Value);
sb.Append(';');
}
return(sb.ToString());
}