如何将SQL Server存储过程转换为MS Access存储过程 [英] How to convert SQL Server Stored Procedure to MS Access Stored Procedure

问题描述

我在sqlexpress 2005中编写了一个具有很多存储过程的数据库应用程序.
现在我想将数据库更改为MS ACCESS.
问题是如何在MS Access中转换那些存储过程.

Thanx in Advance寻求帮助.

I have an application written having database in sqlexpress 2005 with a lot of stored procedures.
Now i want to change the database to MS ACCESS.
The problem is how do i convert those stored procedures in MS Access.

Thanx in Advance for help.

推荐答案

这是一个有点奇怪的请求，因为大多数人都采用另一种方式-从Access到SQLServer.

但是，有几种选择.我不知道有什么工具可以帮助您解决这个问题，因此所有工具都涉及大量复制，粘贴，测试/编辑/测试/编辑等操作.

最好的选择是使用一个搜索引擎，该引擎使用诸如 sqlserver存储过程访问或将sqlserver存储过程访问或类似的搜索词.

This is a slightly odd request, in that most people go the other way - from Access to SQLServer.

However, there are several options. I do not know of any tools that can help with this so all of them involve a lot of copy, paste, test/edit/test/edit etc.

Your best bet would be to use a search engine using search terms like sqlserver stored procedure to access or convert sqlserver stored procedure to access or similar.

这篇关于如何将SQL Server存储过程转换为MS Access存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！