how do i run liked table manager automatic

G

Guest

I want to autoupdate every hour a flat CSV file. I have linked my CSV files
to the tables section. How do i set up the auto update every hour?
 
S

Steve Schapel

Chris,

You can assign your macro on the On Timer event property of a form which
will be open at the time. Set the Timer Interval property of the form
to 3600000 (milliseconds).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

send reminder email through outlook based on info from a csv/excel file 0
Need to TransferText "LIKE" ... 5
How can I speed up doing loads of "INSERT INTO" statements 3
Import CSV question 6
Macro to Auto run 1
Auto import/refresh macro 0
Excel Vlookup and sumif function maybe a macro issue? 0
Export Pivot table 1

Top