How to Read Excel Data and Insert to Database Table in C#

using System;
using System.Data.SqlClient;
using IronXL;

// This C# program reads an Excel file and inserts its data into a SQL database table.
class ExcelToSqlImporter
{
    static void Main()
    {
        // Define the connection string for the SQL Server
        string connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";

        // Open a connection to the database
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            Console.WriteLine("Database connection opened successfully.");

            // Load the Excel file into the IronXL WorkBook
            WorkBook workbook = WorkBook.Load("example.xlsx");
            WorkSheet sheet = workbook.WorkSheets.First();

            // Iterate over the rows in the Excel sheet
            foreach (var row in sheet.Rows)
            {
                // Retrieve cell data
                string column1 = row["A"].Text;
                string column2 = row["B"].Text;
                string column3 = row["C"].Text;

                // Define the SQL Insert command with parameters
                string sqlInsert = "INSERT INTO MyTable (Column1, Column2, Column3) VALUES (@column1, @column2, @column3)";

                using (SqlCommand command = new SqlCommand(sqlInsert, connection))
                {
                    // Set the parameter values
                    command.Parameters.AddWithValue("@column1", column1);
                    command.Parameters.AddWithValue("@column2", column2);
                    command.Parameters.AddWithValue("@column3", column3);

                    // Execute the command
                    command.ExecuteNonQuery();
                }
            }

            Console.WriteLine("Data imported successfully.");
        }
    }
}

Imports System
Imports System.Data.SqlClient
Imports IronXL

' This C# program reads an Excel file and inserts its data into a SQL database table.
Friend Class ExcelToSqlImporter
	Shared Sub Main()
		' Define the connection string for the SQL Server
		Dim connectionString As String = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"

		' Open a connection to the database
		Using connection As New SqlConnection(connectionString)
			connection.Open()
			Console.WriteLine("Database connection opened successfully.")

			' Load the Excel file into the IronXL WorkBook
			Dim workbook As WorkBook = WorkBook.Load("example.xlsx")
			Dim sheet As WorkSheet = workbook.WorkSheets.First()

			' Iterate over the rows in the Excel sheet
			For Each row In sheet.Rows
				' Retrieve cell data
				Dim column1 As String = row("A").Text
				Dim column2 As String = row("B").Text
				Dim column3 As String = row("C").Text

				' Define the SQL Insert command with parameters
				Dim sqlInsert As String = "INSERT INTO MyTable (Column1, Column2, Column3) VALUES (@column1, @column2, @column3)"

				Using command As New SqlCommand(sqlInsert, connection)
					' Set the parameter values
					command.Parameters.AddWithValue("@column1", column1)
					command.Parameters.AddWithValue("@column2", column2)
					command.Parameters.AddWithValue("@column3", column3)

					' Execute the command
					command.ExecuteNonQuery()
				End Using
			Next row

			Console.WriteLine("Data imported successfully.")
		End Using
	End Sub
End Class