exporting Table to Excel file by TSQL Problem

[mhd sbt]

hi all im trying to export table loan to excel file but i get this error in sql 2008 r2

Msg 7308, Level 16, State 1, Line 2
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

my query is

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [Bankmellat$]') select * from BML.Loan

anyone can help me for fix this problem thanks regards

[Lost User]

Try this[^].

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

[mhd sbt]

i do your solution but i get error and my problem is stable and i get error again.

[Lost User]

What error? The same error? Or another? Are you on a 64-bit machine?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

[mhd sbt]

yes i get the same error . yes my machine is 64 bit

[Lost User]

The JET-provider needs to be 64-bit too. Try downloading[^] the newer version.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]