Importing Oracle tables thru OBDC

[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...

 

[Jeff Boyce]

Do the table names change? It seems like a very unusual Oracle db if it has
tables with changing names.

Do you have to import? Can you link to the tables instead?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[btee]

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.

 

[Jeff Boyce]

So you are looking for a way for Access to "know" that new tables have been
added? How would you instruct a human assistant to know?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/