Access Macro

[Anonymous]

My company has an access Macro that is manually run every week. Part of the process is deleting files and copying files between folders. I would like call this macro from Talend. Could someone please show me how to call an access macro from talend? 

[vapukov]

do You really need this?!

why not re-create this functional with Talend? much more relevant system for this

in worst case - use tSystem component

https://answers.microsoft.com/en-us/office/forum/office_2007-access/running-access-macro-from-batch-...

https://social.msdn.microsoft.com/Forums/office/en-US/8cd7fe59-e204-4657-9386-1a5ad3663ca7/batch-fil...

https://stackoverflow.com/questions/15220462/batch-file-to-run-an-ms-access-query-and

[aashish_21nov]

Hello @Robert_gill

you can call macro from talend by tSystem Component.

In tSystem, we call a batch file and in batch file we can call .vbs (visual basic script).