By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,490 Members | 3,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,490 IT Pros & Developers. It's quick & easy.

Converting SQL Server Stored Procedures to MS-Access

P: n/a
Hi,
How can I export SQL Server Stored Procedures to MS-Access?

Cheers

H

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

sollento wrote:
Hi,
How can I export SQL Server Stored Procedures to MS-Access?

Cheers

H


Open the SQL Server SPROC in Query Analyzer, copy the SQL itself, open
a new query in Access, paste in the SQL, making sure that there are no
"gotchas" such as SQL Server user-defined functions etc. I know of no
way to automate this process, though there may be one.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.