import sql to excel

Question

Hi friend,

When i import sql data to excel i am using folling sql query,

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=D:\temp_auto\dr_rep\Coimbatore_Daily_Report.xls;',

'select * FROM [Collection$]')

select * from #temp2_coimbatore_col
but,
i get this error message.


OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

please any one help me.
I don't how it solve this solution.I am tried more time but,i am not getting correct solution.
Please any one solve this solution with example query.