Pull data from query in ODBC Teradata into a table in access

Hi ,

I am trying to get data from a query executed on Teradata ODBC and put the results in a table in access database. And I want to automate this as well (like have a button that runs the query in Teradata and pulls the result of a table into a specific table in the access Database.  Can this be achieved in Access I couldn't find any resources online for the same, please point me in the right direction.

Thanks