MS Access, VB6, ODBC

Is it possible, under program control, to dynamically add a ODBC Linked table into access?

ie I want to create a tempory table in Access which is looking at another database using the ODBC interface