Export sp data to excel problem

M

Martin D

I have a procedure which runs the following command in MS Access 2007;

sp = "EXEC rsp_PropertyClass @CONTRACT='MA2',@PROPERTYCLASS=' All' "
DoCmd.OutputTo acOutputStoredProcedure, sp, acFormatXLS, , True

It fails to run and gives me a incorrect syntax error, but if I run EXEC
rsp_PropertyClass @CONTRACT='MA2',@PROPERTYCLASS=' All' on the sql server it
runs fine.

Why would this happen?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export store procedure data to XML 0
acOutputStoredProcedure not printing Excel file 5
Problems Exporting SP to excel via docmd.outputto 1
Exporting ACCESS Stored Procs into Excel 3
outputtofile not working in 2003 3
EXEC sp w/ BULK INSERT - problem w/ security 2
EXEC SP from Button 1
Export Report to Excel not working? 0

Top