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

4 votes191 views3 answers
Sql drop database if exists
SQL
0 vote183 views2 answers
Postgresql get last day of month
SQL
0 vote165 views1 answer
Postgres add prefix to primary key
SQL
0 vote168 views1 answer
Mysql drop multiple tables at once
SQL
0 vote191 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote172 views1 answer
Where case insensitive like mysql
SQL
1 vote181 views1 answer
Where database run
SQL
0 vote186 views1 answer
Microsoft sql server python connection
SQL
1 vote171 views1 answer
Mysql random limit 1
SQL
13 votes176 views4 answers
Mysql get last row
SQL