Error 3251 - Operation is not supported for this type of Object 1

[GJP55]

I am trying to export a pass through query using the following code:


DoCmd.TransferText acExportDelim, "MyExport", "test123",
"C:\Temp\Test.csv", False, ""

The Pass through query is a stored procedure on our backend SQL database. When I try and run this, I get "Error 3251 - Operation is not supported for this type of Object." Is there a library reference that I am missing ?

 

[hneal98]

create another query based on the pass through and then do your transfertext based on the new query.

 

[GJP55]

Thats great and works perfectly.

Thanks