Access auto import excel recurring process RRS feed

  • 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 !

    Wednesday, February 1, 2017 3:51 PM

All replies

  • 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...

    Wednesday, February 1, 2017 4:22 PM