急求将excel数据导入新建dBase数据库的快捷方法。
本人目前采用的方式是OleDb连接excel数据库,将数据导入DataSet,然后新建dBase数据库,将DataSet表内的数据逐行写于数据库,虽然可以实现,但是速度很慢,4000行记录要将近3min,有没有很快捷的方式或者块操作?
本人目前采用的方式是OleDb连接excel数据库,将数据导入DataSet,然后新建dBase数据库,将DataSet表内的数据逐行写于数据库,虽然可以实现,但是速度很慢,4000行记录要将近3min,有没有很快捷的方式或者块操作?
{
SqlBulkCopy blkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, transaction);
blkCopy.BatchSize = dt.Rows.Count;
blkCopy.DestinationTableName = "TableName";
blkCopy.ColumnMappings.Add("a", "a");
blkCopy.ColumnMappings.Add("b", "b");
blkCopy.ColumnMappings.Add("v", "v");
blkCopy.ColumnMappings.Add("d", "d");
blkCopy.ColumnMappings.Add("e", "e");
blkCopy.ColumnMappings.Add("f", "f");
//blkCopy.ColumnMappings.Add("g", "g"); try
{
blkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
blkCopy.Close();
}
}
{
SqlBulkCopy blkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, transaction);
blkCopy.BatchSize = dt.Rows.Count;
blkCopy.DestinationTableName = "TableName";
blkCopy.ColumnMappings.Add("a", "a");
blkCopy.ColumnMappings.Add("b", "b");
blkCopy.ColumnMappings.Add("v", "v");
blkCopy.ColumnMappings.Add("d", "d");
blkCopy.ColumnMappings.Add("e", "e");
blkCopy.ColumnMappings.Add("f", "f");
//blkCopy.ColumnMappings.Add("g", "g"); try
{
blkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
blkCopy.Close();
}
}
{
DataTable dt = null;
string connetionStr = "Provider=Microsoft.Ace.OleDb.12.0;" + "Data Source=" + url + ";" + "Extended Properties='Excel 12.0;HDR=Yes;IMEX=1';";
string strSql = "select * from [Sheet1$]";
OleDbConnection oleConn = new OleDbConnection(connetionStr);
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(strSql, connetionStr);
try
{
dt = new DataTable();
oleAdapter.Fill(dt);
//dt.AcceptChanges(); return dt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oleAdapter.Dispose();
oleConn.Close();
oleConn.Dispose();
}
}
{
DataTable dt = null;
string connetionStr = "Provider=Microsoft.Ace.OleDb.12.0;" + "Data Source=" + url + ";" + "Extended Properties='Excel 12.0;HDR=Yes;IMEX=1';";
string strSql = "select * from [Sheet1$]";
OleDbConnection oleConn = new OleDbConnection(connetionStr);
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(strSql, connetionStr);
try
{
dt = new DataTable();
oleAdapter.Fill(dt);
//dt.AcceptChanges(); return dt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oleAdapter.Dispose();
oleConn.Close();
oleConn.Dispose();
}
}
{
DataTable dt = null;
string connetionStr = "Provider=Microsoft.Ace.OleDb.12.0;" + "Data Source=" + url + ";" + "Extended Properties='Excel 12.0;HDR=Yes;IMEX=1';";
string strSql = "select * from [Sheet1$]";
OleDbConnection oleConn = new OleDbConnection(connetionStr);
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(strSql, connetionStr);
try
{
dt = new DataTable();
oleAdapter.Fill(dt);
//dt.AcceptChanges(); return dt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oleAdapter.Dispose();
oleConn.Close();
oleConn.Dispose();
}
}
我想问的是怎么新建一个dBaseIV的dbf数据库,把excel里面的数据全部导进dbf文件。
我想问的是怎么新建一个dBaseIV的dbf数据库,把excel里面的数据全部导进dbf文件。