Hi all. On a daily basis, I need to copy 7 tables from a SQL database to an Access database. The process that I go through is such:
Open the access db --> File --> Get External Data --> Import --> Select my ODBC database and log in --> Select my 7 Import Objects (tables) and OK to start.
I would love to create a macro or a DTS package to do this but am very short on knowledge in that area.
Any help is appreciated.