Stored Procedure

[dmcgimpsey]

Hi There

I am trying to create a stored procedure in Access that accepts up to three parameters.

Is there an example anywhere that will do what I wish? I would like to call the SP from Excel. I am not having much luck, there are too many examples out there, and I haven't been able to get one to work.

By the way, where do I execute the code? In the VB window?

Thanks in advance, I am under tight deadline, and appreciate any help. I am managing to stay ahead of the game by doing things manually, and having one sql interface for each Excel Workbook, but that will require over 300 workbooks, so I need an alternative.

 

[mdmilner]

Access doesn't have "stored procedures" from the SQL Server type of definition. You can, on the other hand, create VBA Procedures that accept variables. (fixed, optional or even variable # of them)

Sub AcceptVariables(varName As varType)

End Sub

varType has to be one of the standard ones.

Here's a link to execute xls macros from Access vba
http://www.mvps.org/access/modules/mdl0007.htm

Peek here for your actual question Excel running Access
http://www.mrexcel.com/board2/viewtopic.php?t=82219&highlight=run+access+macro

Although they didn't answer, and I've never tried to run Access VBA from Excel...I'm suspicios that the command is:

DoCmd.RunCode codemodulename

 

[dmcgimpsey]

I managed to get a sample of code that worked.

Now I just have to figure out how to pass the parameters from a VB call from Excel.

Have a nice day.