怎样把EXCEL数据转入SQL2005中?解决方案

怎样把EXCEL数据转入SQL2005中?
我有一个EXCEL文件,想把它转入我的SQL服务器中 按照下面的代码执行后 会报很多错:

C# code

using System;using System.Data;using System.Windows.Forms;using System.Data.OleDb;namespace WindowsApplication2{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void button1_Click(object sender, EventArgs e)        {            //测试，将excel中的sheet1导入到sqlserver中               string connString = "Data Source=19F671E5918A46D;Database=AAA;User id=sa;pwd=SQL4567";            System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();            if (fd.ShowDialog() == DialogResult.OK)            {                TransferData(fd.FileName, "sheet1", connString);            }        }        public void TransferData(string excelFile, string sheetName, string connectionString)           {               DataSet ds = new DataSet();               try              {                   //获取全部数据                   string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelFile + ";" + "Extended Properties=Excel 8.0;";                   OleDbConnection conn = new OleDbConnection(strConn);                   conn.Open();                   string strExcel = "";                   OleDbDataAdapter myCommand = null;                   strExcel = string.Format("select * from [{0}$]", sheetName);                   myCommand = new OleDbDataAdapter(strExcel, strConn);                   myCommand.Fill(ds, sheetName);                     //如果目标表不存在则创建                   string strSql = string.Format("if object_id('{0}') is null create table {0}(", sheetName);                   foreach (System.Data.DataColumn c in ds.Tables[0].Columns)                   {                       strSql += string.Format("[{0}] varchar(255),", c.ColumnName);                   }                   strSql = strSql.Trim(',') + ")";                     using (System.Data.SqlClient.SqlConnection sqlconn = new System.Data.SqlClient.SqlConnection(connectionString))                   {                       sqlconn.Open();                       System.Data.SqlClient.SqlCommand command = sqlconn.CreateCommand();                       command.CommandText = strSql;                       command.ExecuteNonQuery();                       sqlconn.Close();                   }                   //用bcp导入数据                   using (System.Data.SqlClient.SqlBulkCopy bcp = new System.Data.SqlClient.SqlBulkCopy(connectionString))                   {                       bcp.SqlRowsCopied += new System.Data.SqlClient.SqlRowsCopiedEventHandler(bcp_SqlRowsCopied);                       bcp.BatchSize = 100;//每次传输的行数                       bcp.NotifyAfter = 100;//进度提示的行数                       bcp.DestinationTableName = sheetName;//目标表                       bcp.WriteToServer(ds.Tables[0]);                   }               }               catch (Exception ex)               {                   System.Windows.Forms.MessageBox.Show(ex.Message);               }             }        //进度显示           void bcp_SqlRowsCopied(object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e)        {            this.Text = e.RowsCopied.ToString();            this.Update();        }    }}

报的错是:
错误1应输入 )C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Form1.cs4643EXCEL-to-SQL
错误2无效的表达式项“,”C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Form1.cs4644EXCEL-to-SQL
错误3无效的表达式项“)”C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Form1.cs4651EXCEL-to-SQL
错误4“WindowsApplication2.Form1”并不包含“Form1_Load”的定义C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Form1.Designer.cs4055EXCEL-to-SQL

错误5找不到类型或命名空间名称“Form1”(是否缺少 using 指令或程序集引用?)C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Program.cs1733EXCEL-to-SQL
错误6与“System.Windows.Forms.Application.Run(System.Windows.Forms.Form)”最匹配的重载方法具有一些无效参数C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Program.cs1713EXCEL-to-SQL
错误7参数“1”: 无法从“Form1”转换为“System.Windows.Forms.Form”C:\Documents and Settings\祈风\My Documents\Visual Studio 2005\Projects\EXCEL-to-SQL\EXCEL-to-SQL\Program.cs1729EXCEL-to-SQL

到底是哪里错了饿? 有没有其他的方法可以帮我转存数据吗?

[解决办法]
上传EXCEL文件

C# code

protected void btnUpdateComment_Click(object sender, EventArgs e) {            //第一步,上传EXCEL到服务器端            if (FileUpload1.HasFile) {                //验证EXCEL文件格式                if (FileUpload1.FileName.ToLower().IndexOf(".xls") == -1) {                    RequiredFieldValidator1.ErrorMessage = "不是有效的Excel文件";                    RequiredFieldValidator1.IsValid = false;                    return;                }                //EXCEL评论保存位置                string _FilePath = string.Empty;                if (System.Configuration.ConfigurationManager.AppSettings["CommentExcelFile"] != null)ent 

 

查看更多 下一篇