public static int DataTableExportToAccess(DataTable dt, string filename, String tabName)
{
Stopwatch watch = Stopwatch.StartNew();
watch.Start();
if (dt.Rows.Count <= 0)
{
return -1;
}
string connString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", filename);
DBUtility.DbHelperOleDb oledb = new DBUtility.DbHelperOleDb();
IList<string> maplist = new List<string>();
int cols = dt.Columns.Count;
for (int i = 0; i < cols; i++)
{
maplist.Add(dt.Columns[i].ColumnName.ToString());
}
oledb.DatatableImport(connString,maplist, tabName, dt,true);
watch.Stop();
return Convert.ToInt32(watch.ElapsedMilliseconds / 1000);
}
public static int DataTableExportToAccess(DataTable dt, string filename, String tabName)
{
Stopwatch watch = Stopwatch.StartNew();
watch.Start();
if (dt.Rows.Count <= 0)
{
return(-1);
}
string connString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", filename);
DBUtility.DbHelperOleDb oledb = new DBUtility.DbHelperOleDb();
IList <string> maplist = new List <string>();
int cols = dt.Columns.Count;
for (int i = 0; i < cols; i++)
{
maplist.Add(dt.Columns[i].ColumnName.ToString());
}
oledb.DatatableImport(connString, maplist, tabName, dt, true);
watch.Stop();
return(Convert.ToInt32(watch.ElapsedMilliseconds / 1000));
}
