I am a beginner(a student as well) to database programming.
I am doing an automatically updated database which imports data from an excel
spreadsheet. The excel spreadsheet is doing a web query and the data inside
is changing every minute in real time. I would like to ask how can I update
my access database automatically every minute by appending new records??(using
macros? or write vba procedures? how?)
(I am able to run the macro manually but I would like to make it run automatically
after certain interval.) due to there is interior setting in access that
perform such a execution.
I hope your all can help me.
Any suggestions ang ideas are highly appreciated.