[AccessD] A2003:Importing/Linking SQL Tables (and data)

Hello all
When I use something like 
    DoCmd.TransferDatabase acImport, "ODBC", "PhoneCentral", acTable,
"SQLTABLENAME", "MDBTABLENAME", False
To import some SQL tables I expected to see the Standard ODBC password login
stuff
Instead I get an error message
Run Time Error 3170
Could not fin installable ISAM

Does anyone have some code where I can loop through a recordset of
tablenames 
And import them from SQL into an AccessdB
And the same for linking as well?

Many thanks

Darren