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 vote268 views1 answer
Oracle transaction rollback not working
SQL
0 vote191 views2 answers
Which MySQL statement is used to delete data from a database
SQL
27 votes220 views5 answers
Mysql set password for user
SQL
0 vote184 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote223 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote170 views2 answers
Add new column after in sql
SQL
0 vote212 views1 answer
How to find date from date table in sql
SQL
0 vote194 views3 answers
Sql drop all tables
SQL
0 vote186 views2 answers
Temp Space
SQL
0 vote190 views1 answer
Casterar postgres
SQL