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.

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


"ads" <(E-Mail Removed)> wrote in message
news:C2679203-9DD1-44D0-AA68-(E-Mail Removed)...
> 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.