471,616 Members | 1,159 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,616 software developers and data experts.

Shift or Copy Data from Sqlserver to MS Access using Stored procedure

hariharanmca
1,977 1GB
How to Shift or Copy Data from Sqlserver to MS Access using Stored procedure
I am passing the clint MS Access file path in that i want to insert or update data in that MS Access file using Store Procedure.

Thank you
Mar 8 '07 #1
1 2195
dorinbogdan
839 Expert 512MB
This MSDN states that:
The OPENROWSET function can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.

See the Access sample there.
Mar 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Doug R | last post: by
5 posts views Thread by pmud | last post: by
41 posts views Thread by laimis | last post: by
5 posts views Thread by Tina | last post: by
6 posts views Thread by insirawali | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.