string SQL = "";
Database database = DatabaseFactory.CreateDatabase();
try
{
SQL = "if exists(select * from sysobjects where id=object_id('ExcelToData')) drop table ExcelToData";
DbCommand dbcommand = database.GetSqlStringCommand(SQL);
database.ExecuteNonQuery(dbcommand);
SQL = "select * into ExcelToData";
SQL += " FROM OpenDataSource( 'Microsoft.Jet.OLEDB.12.0','Data Source=\"" + strDataFilePath + "\";User ID=sa;Password=sa;Extended properties=Excel 12.0')...[Sheet1$]";
DbCommand dbcommand1 = database.GetSqlStringCommand(SQL);
database.ExecuteNonQuery(dbcommand1);
Database database = DatabaseFactory.CreateDatabase();
try
{
SQL = "if exists(select * from sysobjects where id=object_id('ExcelToData')) drop table ExcelToData";
DbCommand dbcommand = database.GetSqlStringCommand(SQL);
database.ExecuteNonQuery(dbcommand);
SQL = "select * into ExcelToData";
SQL += " FROM OpenDataSource( 'Microsoft.Jet.OLEDB.12.0','Data Source=\"" + strDataFilePath + "\";User ID=sa;Password=sa;Extended properties=Excel 12.0')...[Sheet1$]";
DbCommand dbcommand1 = database.GetSqlStringCommand(SQL);
database.ExecuteNonQuery(dbcommand1);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货