Excel imports SQL Server database Scripts _mssql

By the old colleague of the past, in the blog post this script:

exec sp_configure ' show advanced options ', 1
Reconfigure
exec sp_configure ' Ad Hoc distributed Queries ', 1
Reconfigure

SELECT * into Tmp_asset
From OPENROWSET (' microsoft.jet.oledb.4.0 ',
' Excel 8.0;database=d:\excel data source \ asset seal. xls ',
' SELECT * from [sheet1$] ');

Description

D:\Excel data source \ asset seal. xls---------> Physical path for files.

From [sheet1$]----------> Sheet1 is the name of the worksheet.

The rest is the Tmp_asset related columns to do some data matching, here is not much to say: