access database: automatic update??
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL