Import Data in SQL Server Table From Excel

How to import data in sql server table from excel spreadsheet
In this tutorial you will learn how to import data into sql server table from an excel spreadsheet using SQL Import and Export Wizard with easy steps. Let start doing it step by step.
Step 1: Pick your Excel source

Step 2: Pick your SQL Server target database

Step 3: Pick your source worksheet (from Excel) and your target table in your SQL Server database; see the "Edit Mappings" button!

Step 4: Check (and change, if needed) your mappings of Excel columns to SQL Server columns in the table:

Step 5: If you want to use it later on, save your SSIS package to SQL Server:

Step 6: Success! This is on a 64-bit machine, works like a charm - just do it!!

Comments and Suggestions are always Welcome!