本文介绍了在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中创建存储过程吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-13 11:55