Menu
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.
Thanks
581
Creates a stored procedure. Note: The Microsoft Access database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements, with non-Microsoft Access database engine databases.
The equivalent to an INSERT, UPDATE or DELETE query in SQL Server is a stored procedure. Stored procedures are in fact more flexible than a simple query that performs one step; for example, updating data in a single table. They are mini programs that can range from a few lines to several pages of code.
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 using a function. I found a tutorial here. But I haven't tried this approach.SQLServer Stored Procedure and Import it in Acess. Try this link if you like this approach. Named Macros.Hope this helps.
117
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
