Export for the excel a Stored Procedure passing parameters

G

galina

If anybody knows please help me. I need to export to the excel a stored
procedure with parameters. I am doing (simple version):

Dim par1 as String
Dim par2 as Integer
par1=Me.txtCust.Value
par2=Me.txtOrder.Value
DoCmd.OutputTo acOutputStoredProcedure, "sproc_Culc" & " '" & par1 &
"'," & par2,acFormatXLS, "Order.xls",True

I have an error "Invalid Object".

I anybody knows please e-mail me (e-mail address removed)

Thanks in advance, Galina.
 

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

Return Values from SQL Server to MS Access 1
Create Procedure query in Access. 5
Return Values from SQL Server to MS Access 1
Pass a variable value to multiple text boxes in order 2
Export to Excel with Parameter in Filename 1
Exporting ACCESS Stored Procs into Excel 3
How to pass parameters to excel from wscript (Windows script) 5
how to code a button to export results of stored procedure to excel file 0

Top