Export store procedure data to XML

[Martin D]

I'm having problems trying to export the data returned from a store procedure
which uses parameters in to an xml formt.

This is the code i'm using;
DoCmd.OutputTo acOutputStoredProcedure, "exec
dbo.rsp_ContractPropsAndAppliances 'MA2',' ALL DISTRICTS'"

When you are asked to speficy the format to use, if I select exel it outputs
fine, but if I select xml it gives the following error;

db Cannot find object exec dbo.rsp_ContractPropsAndAppliances 'MA2',' ALL
DISTRICTS'

If I take the parameters out it prompts for them and when there are entered
it works, grrr

I'm using 2007 and sql 2005

Any Ideas?