Previous Discussion	Next Discussion

Data from SQL to Access? Hi everybody, I hope you guys can guide me. What I am trying to do is to keep a local (Access db) short version of critical data from the SQL DB so that the system can operate offline (with limitations of course) in the event of network breakdown. I Intent to create a service to refresh certain data every x minutes (I know this will generate a lot network trafic, but the benefits are worth it) I am looking for the most efficient way to retrieve data from and SQL DB and insert it in an Access DB. I know how to do this one record at a time using the respective oledb and sqlclient classes, but is there a way to do this as a batch? Thank you great minds for your time and help. Alex. Started By okyakusan on Aug 28, 2008 at 5:54:03 AM

7 Response(s) | Reply

Earlier Replies | Replies 5 to 7 of 7 | Later Replies Goto Page: 1

okyakusan on Sep 9, 2008 at 3:59:26 AM (# 5) I figured it out, thanks! fishermanusa on Sep 10, 2008 at 8:13:20 AM (# 6) This is good information.It helped me to solve a problem Great book Visit Us For good WEB Design Services | Engineering Forum | Automation Forum | Automation | Engineering | Industries kianurieves on Sep 24, 2012 at 9:38:50 PM (# 7) Importing SQL Server data creates a copy of the data in an Access database. During the import operation, you specify the tables or views that you want to copy.The import operation creates a table in Access and then copies the data from the SQL Server database into the Access table. http://www.dapfor.com/en/net-suite/net-grid/features/performance

Earlier Replies | Replies 5 to 7 of 7 | Later Replies Goto Page: 1

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.