如何使用C#将excel文件中的数据插入microsoft localdb数据库

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

string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\DatabaseName.mdf;Integrated Security=True";

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();
    OleDbCommand excelCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", excelConnection);
    OleDbDataReader excelDataReader = excelCommand.ExecuteReader();
    while (excelDataReader.Read())
    {
        // 读取Excel中的数据并进行处理
        string column1Value = excelDataReader.GetString(0);
        string column2Value = excelDataReader.GetString(1);
        // ...
    }
    excelDataReader.Close();
}

using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
    sqlConnection.Open();
    string insertQuery = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)";
    using (SqlCommand sqlCommand = new SqlCommand(insertQuery, sqlConnection))
    {
        sqlCommand.Parameters.AddWithValue("@Value1", column1Value);
        sqlCommand.Parameters.AddWithValue("@Value2", column2Value);
        // ...
        sqlCommand.ExecuteNonQuery();
    }
}