I'm trying to export data from a table into an Excel spreadsheet using this code

Use Northwind
GO
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT OrderID, CustomerID FROM [Sheet1$]') select OrderID, CustomerID from Orders
GO

It returns this error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].

I set up the spreadsheet with "OrderID" in cell A1 and "CustomerID" in cell B1.
Any help would be appreciated.

Thanks

Hi,
It should be
Use Northwind
GO
insert into Orders -- are you trying to insert into orders???
select OrderID, CustomerID from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT OrderID, CustomerID FROM [Sheet1$]')
GO

you can comment out the insert to get the resultset only
select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT OrderID, CustomerID FROM [Sheet1$]')
GO




------------------------------------------ http://sqlservercode.blogspot.com/

I'm trying to insert data into the spreadsheet. (i.e. export out of SQL Server into Excel)

you will have to use DTS for that

------------------------------------------ http://sqlservercode.blogspot.com/