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 vote175 views1 answer
Name of today sql
SQL
4 votes157 views1 answer
Postgresql show current database
SQL
6 votes178 views1 answer
Allsource oracle
SQL
0 vote228 views1 answer
TSQL Find csv file in folder
SQL
0 vote151 views1 answer
Duplicate foreign key constraint name
SQL
0 vote206 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote167 views1 answer
Sql server select top 2 of each group
SQL
0 vote216 views1 answer
Mql5 datetime get hour
SQL
0 vote177 views1 answer
Difference between 2 query results sql server
SQL
0 vote169 views1 answer
Oracle exchange partition
SQL