Link ODBC table in Access

Luke29

New Member

Join Date: Oct 2007

Posts: 1
#1

Link ODBC table in Access

Oct 30 '07, 10:08 AM

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
Tags: None
shrimant

New Member

Join Date: Sep 2007

Posts: 48
#2

Oct 30 '07, 11:30 PM

Originally posted by Luke29

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

Create a View with selected columns and link to the View
Comment

Comment