Hiya all, this is my first post here. I hope you can help me.
I have a trigger attached to a table that will export data to an Excel spreadsheet when a record is inserted to that table. When I insert the record, I get the following error:
The current transaction could not be exported to the remote provider. It has been rolled back.
The script I am using is below:
Insert into OpenDataSource
'Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\ITTeam\Excel\Book1.xls;Extended Properties=Excel 8.0'
SELECT * FROM CUSTOMERS
I think the script is OK because it works when:
1. I execute the script from a SqlClient.SqlCommand object within a VB .Net application
2. If I place the script in a stored procedure and execute it from a VB .Net application.
Thanks in anticipation