SQL Server SQL statement import data into execl2007

Insert into OPENROWSET (' microsoft.ace.oledb.12.0 ', ' Excel 12.0;database=c:\c.xlsx ', ' Select field 1, Field 2 from [sheet1$] ')
Select field 1, Field 2 from table

Today, the unit of an ASP, there is a function is exported data, found an export error, error content is:SQL Server blocked the component ' Ad Hoc distributed Queries ' STATEMENT ' Openrowset/opendatasource ' access because this component has been shut down as part of this server's security configuration. System administrators can enable ' Ad Hoc distributed Queries ' by using sp_configure. For more information about enabling ' Ad Hoc distributed Queries ', see "surface area Configurator" in SQL Server Books Online.

Look at the error notice because SQL Server's Ad hoc distributed queries component is disabled, and here I use the SQL Server version is 2005, only need to open ad hoc distributed Queries, here's how it works:

1. Open the ad HOC distributed queries component and execute the following statement in the SQL Query Editor:

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

2. Close the ad HOC distributed queries component and execute the following statement in the SQL Query Editor:

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

SQL Server SQL statement import data into execl2007