How to import data from an Excel file in a database

How to easily import files in Excel format in a database

1) Open SQL Server, locate the database you want to import data from, right >> task >> import data

2) Select the Excel you want to import by following the diagram

3) Select which database to import into

4) Import Excel Select the first item, select the second item is the filter copy of the table and the direct contents of the table

5) Select the source table and source view to preview the data in the table

6) Edit the mapping page (as in the previous step)

7) Continue to the next step, click Finish to see the Transfer Data completion page

8) Go to the database refresh, view the table just imported, complete!

How to import data from an Excel file in a database