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

8 votes249 views1 answer
Insert a select statement into a table
SQL
7 votes270 views1 answer
Sql pagination oracle
SQL
0 vote254 views1 answer
Drop all triggers oracle
SQL
3 votes260 views2 answers
Mysql user permission database
SQL
17 votes259 views6 answers
Sql select distinct
SQL
0 vote262 views1 answer
Python connect microsoft sql server
SQL
0 vote242 views1 answer
Import mysql'
SQL
0 vote294 views1 answer
Typical max-connect-errors mysql
SQL
2 votes249 views1 answer
How to check grants on a package in oracle
SQL
0 vote268 views2 answers
Dbms interview questions
SQL