Automate: 1) wipe out table and 2) copy data from another table to it

Using VBA/DAO for Excel 2010, originally I was pulling data from a table in Access that was linked/sync'd with a SharePoint list. The query was somewhat slow, so I created a regular/non-linked Access table and every day I manually append the data from the SharePoint linked table to this other table (I delete all of the data from this other table first) and the query runs much faster. This process isn't too bad as it only takes a few minutes at night, but is there a better way to do this (besides changing the front-end/back-end altogether)?

Is there anyway to automate this job? Maybe using VBA for Access or something? Or is there a way to keep the SharePoint-linked table and the other table (I guess you'd call it a regular table? I dunno) sync'd up automatically? Or at least sync'd up every few minutes or hours?

Thanks!

Thanks for your help!