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 vote247 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
1 vote231 views2 answers
Replace text in sql
SQL
2 votes276 views1 answer
Datefromparts mssql
SQL
0 vote241 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote239 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote233 views1 answer
Kill thread
SQL
0 vote234 views1 answer
Postgres in operator with comma separated values
SQL
1 vote227 views1 answer
How to make a select in sql
SQL
0 vote269 views1 answer
How to get number of months between 2 dates sql server
SQL
2 votes262 views2 answers
Create empty table from existing table
SQL