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 votes283 views1 answer
Sql select limit range
SQL
0 vote228 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote195 views1 answer
Retrieve meaning
SQL
1 vote169 views1 answer
Avg mysql
SQL
2 votes138 views2 answers
Mysql get last character of string
SQL
0 vote178 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes179 views1 answer
How to add where command in update comand with joins
SQL
0 vote180 views1 answer
Show database not empty tables postgres
SQL
0 vote181 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote209 views1 answer
MySQL import data from large CSV file
SQL