Import excel to sql table

Import excel data to new table 

1. Right click on the database select task and import data.
2. select source here MS ExCell
3. select destination here sql server native client last option.
4. enter credentials.
5. then check source and destination . rename destination name as table name.
6. 
   
   
   
7. in the below click on edit mapping compare source column match to destination table column name
   then map both source and destination values then click on finish