excel导入数据库.net

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

class ExcelToDatabase
{
    static void Main()
    {
        string excelFilePath = @"C:\path\to\your\file.xlsx";
        string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=YourDatabase;Integrated Security=True";

        // 连接到Excel文件
        string excelConnectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={excelFilePath};Extended Properties='Excel 12.0;HDR=YES;'";
        using (OleDbConnection excelConnection = new OleDbConnection(excelConnectionString))
        {
            excelConnection.Open();

            // 获取Excel表名
            DataTable sheets = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string sheetName = sheets.Rows[0]["TABLE_NAME"].ToString();

            // 读取Excel数据
            string query = $"SELECT * FROM [{sheetName}]";
            using (OleDbDataAdapter adapter = new OleDbDataAdapter(query, excelConnection))
            {
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);

                // 连接到数据库
                using (SqlConnection sqlConnection = new SqlConnection(connectionString))
                {
                    sqlConnection.Open();

                    // 插入数据到数据库
                    string insertQuery = "INSERT INTO YourTable (Column1, Column2, Column3) VALUES (@Column1, @Column2, @Column3)";
                    using (SqlCommand sqlCommand = new SqlCommand(insertQuery, sqlConnection))
                    {
                        sqlCommand.Parameters.Add("@Column1", SqlDbType.VarChar);
                        sqlCommand.Parameters.Add("@Column2", SqlDbType.Int);
                        sqlCommand.Parameters.Add("@Column3", SqlDbType.DateTime);

                        foreach (DataRow row in dataTable.Rows)
                        {
                            sqlCommand.Parameters["@Column1"].Value = row["Column1"];
                            sqlCommand.Parameters["@Column2"].Value = row["Column2"];
                            sqlCommand.Parameters["@Column3"].Value = row["Column3"];
                            sqlCommand.ExecuteNonQuery();
                        }
                    }
                }
            }
        }
    }
}