Scheduled import between tables?

Hello all.

I need to schedule an overnight task to import some Timberline accounting data (ODBC datasource) into an Access database.  I only need to import 4 or 5 tables, not the whole database, and need to schedule the import for midnight every night.

Is there software out there that does this?  If not, is this relative easy to do myself?

Thanks in advance for any help.

Tony

Can you recommend some resources that show how this is done?

Tony