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 vote179 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
5 votes151 views1 answer
Mysql count lines
SQL
0 vote141 views1 answer
How to connect postgresql database with java
SQL
0 vote159 views1 answer
Postgres regex word boundary
SQL
2 votes149 views1 answer
Oracle virtual column
SQL
0 vote158 views1 answer
Sql combine results from two tables
SQL
0 vote156 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote227 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote185 views1 answer
How to make sure two tables have same exact data in sql
SQL
3 votes150 views2 answers
WhereIn SQL
SQL