Import excel to sql

You can also use OPENROWSET to import excel file in sql server.

SELECT * INTO Your_Table FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
                        'Excel 12.0;Database=C:\temp\MySpreadsheet.xlsx',
                        'SELECT * FROM [Data$]')

Similar codes

0 vote80 views1 answer
Deleted table in sql trigger
SQL
1 vote134 views1 answer
Select 2 rows in sql
SQL
0 vote139 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote126 views1 answer
Hibernate show sql xml property
SQL
0 vote136 views1 answer
Psql show db
SQL
2 votes141 views1 answer
Oracle percentage
SQL
1 vote125 views1 answer
Sql trigger before delete
SQL
6 votes112 views3 answers
Can you update NULL in sql
SQL
2 votes121 views2 answers
Get all tables using like
SQL
2 votes154 views2 answers
Mysql search for column name in all tables
SQL