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

1 vote267 views1 answer
Postgresql update auto_increment value
SQL
0 vote300 views1 answer
Mysql shell ERROR: Not connected.
SQL
10 votes299 views1 answer
User_dependencies
SQL
11 votes310 views1 answer
Oracle view source
SQL
2 votes292 views3 answers
Current month mysql query
SQL
5 votes307 views3 answers
Mysql remove unique constraint
SQL
0 vote288 views1 answer
Trigger value from maltiple table to single table mysql
SQL
-1 vote350 views1 answer
How to Activate the database
SQL
0 vote289 views1 answer
Drop a field in psql django
SQL
1 vote297 views1 answer
How to use a trigger to validate input data
SQL