Problems Exporting SP to excel via docmd.outputto

[Diego]

Hi,

i experience this problem:

I have an SP called Test which expect a date range, so the string to call
the sp is: stSP="EXEC Test '01/01/05','31/12/05'", for example.

I want to export the resultset to excel using:

DoCmd.OutputTo acOutputStoredProcedure , stSP, acFormatXLS, "c:\prova.xls",
1

everyting works, but excel tries to use the name of the SP (stSP) as the
name of the worksheet. But a string with the char (') is not a correct name
ad so when I open the report i get errors on the file name.


Is there a way to solve this? Why can't I specify the name for the sheet? If
I can't use SP with parameters, where is the point of giving this feature?

Thank you very much

 

[giorgio rancati]

Hi Diego,

You can't use SP with parameters.
You can create a temporary view with Sql statment and send it to Excel
spreadshet.
View this thred
----
http://www.google.it/groups?threadm=eL4EA8#[email protected]
----

p.s.
mi sembra di capire che parli Italiano, se vuoi posso spiegarti meglio nel
newsgroup microsoft.public.it.office.access
L'Inglese non è il mio forte

Ciao