how can i write a query to import or export data to a excel sheet or word doc not using the wizard in sql server 2005?

Hi Methsika,

You can use OPENROWSET for loading data into SQL Server. Here is a sample code;

SELECT *
   FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\Test.xls;HDR=NO','SELECT * FROM [Sheet1$]')


Let us know if need more clarification.

hi,

can you explain me what are those parameters in that function and how to export data to an excel or word file in that way?

thanks.