| Data from SQL to Access?|
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.
Started By okyakusan on Aug 28, 2008 at 5:54:03 AM