macro to auto upload data

[chr1stoper1]

Hi guys I would like help to figure out if it is possible to upload data from a source at a specific time every day? using a macro? is this possible and or Is there a better way of doing this ? Cheers for any help

[JoeM]

Sure. Here us one way (there are others).

Make a separate Front-End database which just does the Import, and then closes.
If you place that code in a Macro named "AutoExec", it will run automatically upon opening.
Then you can use Windows Scheduler (or any other Scheduling software you use) to open that Database at a specific time each day.

[chr1stoper1]

Thanks for pointing me in the right direction cheers