insert into openrowset('Microsoft.Jet.OLEDB.4.0','excel 9.0;Database=C:\test.xls;','select column1,column2,column3 from [Sheet1$]')
select column1, columns2, column3 from MyTable

quote:

---

Originally posted by slimt_slimt

the simplest way to do it is to run SELECT statement against your table or query and copy/paste results to excel.
or you can export a table to excel using EXPORT.
or you can even DTS package to save your data to excel.
or you can write query to store data in excel using INSERT INTO OPENROWSET:

insert into openrowset('Microsoft.Jet.OLEDB.4.0','excel 9.0;Database=C:\test.xls;','select column1,column2,column3 from [Sheet1$]')
select column1, columns2, column3 from MyTable


@slimt_slimt: Have errors appeared when i run your code hope you can help me. here is the error:
 [OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:   ].
Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. 

---