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

5 votes185 views3 answers
How to remove unique key constraint in mysql
SQL
2 votes180 views1 answer
Oracle kill job by sid
SQL
0 vote195 views1 answer
Join in update query in mysql
SQL
0 vote185 views1 answer
Can we rollback deleted data in sql
SQL
2 votes193 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
3 votes148 views4 answers
Mysql delete duplicate rows
SQL
0 vote280 views8 answers
Sql to c# linq converter online
SQL
0 vote191 views1 answer
Group by join columns per table
SQL
3 votes210 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
2 votes227 views1 answer
Oracle insert or update
SQL