-2
I am currently doing a series of rather mechanistic tasks and hope to automate them so as to free up my time for other more productive purposes.
The series of tasks that I have to do looks something like this:
- Open up access file.
- Delete a table called 'data'.
- Import an excel file into that access file and name the table 'data'.
- Copy and paste all tables and queries to another excel file, in different sheets but in a same workbook. Then rename some of the sheets.
- Save and close the excel and access files.
I have to do the above sequence of tasks several times a day for many pairs of access and excel files.
How can I automate such a repetitive process? What programming languages/scripts (like, Visual Basic, Windows Batch Script, etc) do I have to learn and how do I combine these skillsets to make this process simpler?
I am not asking for a solution/code to the aforementioned problem. I want to do it by myself but simply don't know where to begin from.
Thank you for your help.
AutoIt can do all that directly for Excel but for Access you'd have to use its Process Management features.. – Chenmunka – 2016-09-28T12:57:22.180
"What programming languages/scripts..." - you can do all of it with VBA (visual basic for applications). – Máté Juhász – 2016-09-28T13:14:35.990