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 vote227 views1 answer
How to find lowest in sql
SQL
0 vote221 views1 answer
The fetch keyword oracle
SQL
0 vote195 views2 answers
Mysql disable foreign key checks
SQL
1 vote232 views1 answer
How do you use sql in you company
SQL
0 vote214 views3 answers
Magento 2 order delete from db
SQL
2 votes271 views4 answers
List databases in sql server
SQL
1 vote205 views2 answers
Postgresql get difference in hours between two dates
SQL
1 vote204 views1 answer
Right outer vs left outer join
SQL
0 vote167 views1 answer
Copy table dbeaver
SQL
5 votes226 views1 answer
Oracle nls parameters
SQL