Need help executing teradata macro from interface.

Third Party Software
Fan

Need help executing teradata macro from interface.

Hi there,
I am pretty new to teradata. Recently I wrote some teradata SQL statements and be able to pull some data to view using SQL assistant for teradata. I then create/save a macro with some parameters and can be able to execute it within teradata SQL assistant, ODBC. Now I need to execute this macro from an MS-access form/interface. Usually, I use ado and dao between vba and SQL server. I've read someone could be able to do this with teradata. Can someone help me with this? Can I use ODBC for this task or I need OLEBD and connection string? Anyone has any code I can learn the syntax from?
Thanks in advance.