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

2 votes137 views1 answer
Date conversion in mysql column
SQL
0 vote136 views1 answer
Sql datediff month
SQL
0 vote98 views1 answer
Postgres delete where id in
SQL
0 vote251 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote125 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote139 views1 answer
Sql select min
SQL
0 vote140 views1 answer
Soql user profile
SQL
0 vote137 views1 answer
Create table like sql
SQL
1 vote141 views1 answer
Round one decimal place mysql
SQL
3 votes145 views2 answers
Search text in all sql server stored procedure
SQL