how can i convert stored procedures in sql to stored queries in ac

[Guest]

How can i convert dozens of stored procedures in a sql server db to stored
queries in access db without doing tedious task?does access queries have
counterparts in sql keywords such as OUTPUT and input parameter variables?i
tried using dts to transfer database objects from sql server db but only
tables and views were transfered. i need to include stored procedures.

i hope someone can help.

thanks.

 

[Michel Walsh]

Hi,

Nope, not directly, but doable. Consider that while in MS SQL Server we have
SQL + TransactSQL, in Access, we have Jet + VBA.

So, somehow, it should be possible, but you would have to do it manually.


Hoping it may help,
Vanderghast, Access MVP