Access auto import excel recurring process

Question

I would like to know how its possible to import (each hour) an excel sheet that refresh each hour in a Access database. Thank you verry much !

Answer 1

Hi,

You can use a Timer event on a form to execute the import process using the TransferSpreadsheet method or create a macro to execute the TransferSpreadsheet method and then use the Task Scheduler to launch the macro using the /x switch in the command line.

Hope it helps...