Using Windows Task Scheduler to append data to an Access table daily
Posted on 2012-03-28
On a recurring daily basis (e.g. 1:00 AM), I need to import a comma delimited text file into an Access 2010 database. The objective is to append the file’s data to a table in the database. I plan to use Windows 'Scheduled Tasks' feature to control the process. I would prefer to have the Scheduler trigger an Access macro that runs a "Saved Import," but I believe I could work with VBA code (a module??) if necessary.
To support the task, I can either leave the database program running all the time, or have the Scheduler turn it on and immediately run the macro or VBA code. I understand the latter is not too good an idea, because (I believe) a manual turn-on would cause the ‘import’ to run --- in which case it could duplicate records entered by the scheduled run.
From my research so far, it doesn’t appear that there is an easy way to set this up without extensive code writing, but I hope I’m wrong.
Does anyone have any ideas, suggestions or thoughts on this subject? Many thanks.
P.S. I am reasonably familiar with macros, I have a raw beginner’s knowledge of VBA, and I am reasonably familiar with the Windows “Scheduled Tasks” feature. But I am not a programmer or a highly advanced user.