Importing Oracle tables thru OBDC

  • Thread starter Thread starter btee
  • Start date Start date
B

btee

I would like to automate the import of Oracles tables into Access several
times a month.

The table names follow the same pattern, so I wanted to use a wildcard
reference when importing the table names. What is the best way to do this in
an Access Macro or Access VBA code?

I'm thinking the only way to do this is to manually connect and select the
tables individually...
 
The table names do not change, but new tables are occassionally added. I
want to be able to pick up the new tables automatically.

I would love to link the tables, but I was instructed not to do so.
 
Back
Top