How to import CSV / Excel file to SQL Server Table

How to Load Excel File / CSV File to a SQL Server Table / Create SQL Server Table from Excel File

Step 1: Select Import and Export Wizard from Program


Step 2: Select Import and Export Wizard from Program

 Step 3: Select Flat File as Source

Step 4: Select the CSV / Text file

Step 5: Choose the Server

Step 6: Choose Database

Step 7: Specify Schema and Table Names

 Step 8: Run the Pachage