sqlServer导出到excel
发布时间：2020-12-12 15:51:31 所属栏目：MsSql教程 来源：网络整理
导读：public void toDb(string fileName) ??????? { ??????????? string execelConnectionStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + @";Extended Properties=""Excel 8.0;HDR=YES;"""; ??????????? try ??????????? { ??????????????
|
public void toDb(string fileName) ??????? { ??????????? string execelConnectionStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + @";Extended Properties=""Excel 8.0;HDR=YES;"""; ??????????? try ??????????? { ??????????????? using (OleDbConnection conn = new OleDbConnection(execelConnectionStr)) ??????????????? { ??????????????????? OleDbCommand cmd = new OleDbCommand("select * FROM [Sheet1$]",conn); ??????????????????? conn.Open(); ??????????????????? using (DbDataReader dr = cmd.ExecuteReader()) ??????????????????? { ??????????????????????? string sqlConnectionString = @"Data Source=数据库服务器;Initial Catalog=数据库名;Persist Security Info=True;User ID=sa;Password=123"; ??????????????????????? // Bulk Copy to SQL Server ??????????????????????? using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString)) ??????????????????????? { ??????????????????????????? bulkCopy.DestinationTableName = "E003"; ??????????????????????????? bulkCopy.WriteToServer(dr); ??????????????????????? } ??????????????????? } ??????????????? } ??????????? } ??????????? catch (Exception ex) ??????????? { ??????????????? ex.ToString(); ??????????? } ??????? }
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |