在MS Access中创建存储过程吗? [英] Create stored procedure in MS Access?

问题描述

我想知道是否可以在Acces数据库中为Insert数据创建StoredProcedure.我已经尝试了几件事，但到目前为止，似乎没有任何解决办法.

I would like to know if it's possible to create a StoredProcedure to Insert data in an Acces database. I've tried a couple of thing but nothing so far seem to do the trick.

谢谢

推荐答案

我知道可以直接在访问中创建Stored Procedure，但这并不是一件很容易的事.

I know it is possible to create a Stored Procedure directly in access but it isn't pretty to do.

从这里开始，您最好的选择是:

Your best options from here would be to :

• 使用功能模拟Stored Procedured.我在此处找到了一个教程.但是我还没有尝试过这种方法.
• 另一种流行的方法似乎是导入SQLServer Stored Procedure并将其导入Acess.尝试此链接(如果您喜欢这种方法).
• 如果您使用的是MS Access 2010，则StoredProcedures将列在Named Macros下的表格标签中.

• Simulate a Stored Procedured using a function. I found a tutorial here. But I haven't tried this approach.
• Another Popular approach seems to be to import an SQLServer Stored Procedure and Import it in Acess. Try this link if you like this approach.
• If your using MS Access 2010, StoredProcedures will be listed in the tables tab under Named Macros.

希望这会有所帮助.

这篇关于在MS Access中创建存储过程吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！