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 votes112 views1 answer
How to check port number for postgresql
SQL
1 vote126 views1 answer
Mysql take number in string
SQL
13 votes111 views2 answers
Display users in mysql
SQL
0 vote108 views1 answer
Get only first row mysql
SQL
0 vote109 views1 answer
Take sql dump in to file
SQL
2 votes107 views1 answer
Convert series number to date in sql
SQL
0 vote111 views1 answer
Oracle db get table sizes
SQL
0 vote131 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
2 votes113 views1 answer
How to search table name in stored procedure in sql server
SQL
-1 vote124 views1 answer
Add 10 to all numbers in a column sql
SQL