I want to link to an oracle table in Access using vba code and can do this using DoCmd.TransferD atabase. But I do not want to link to all the columns in the source table. Is there a way to link to only certain columns?

Cheers