Automate copy of data between 2 tables

[runnerlk]

I have an Access 2010 table that is linked to a SharePoint 2010 list. I am using this table as a datasource for a line of business application. the porblem I just found out is the LOB cannot use a linked table. So I was wondering how I could automate the copy of the data from the linked table to another table. The key is to somehow automate like I would do with a SQL server DTS package.

Thanks

 

[dhookom]

A DTS package can be scheduled. You can create some append, update, and delete queries in an Access application. Then use the Windows scheduler to run the application. You would need to add a command line switch to run a macro or set up autoexec functionality to execute the queries.

Duane
Hook'D on Access
MS Access MVP