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



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.


Michel Walsh


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

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