Link tables

[tripico]

Does anyone know how to link tables automatically/VBA?

I'm trying to import files from our DB2 database in which one file is created monthly and instead of manually importing / linking the files manually, I'm looking to have access link to the new file automatically.

The file names are structured as so..

ITM01 (Jan)
ITM02 (Feb)
ITM03 (March)

Thanks

 

[KeithG]

you can use an ODBC driver.

 

[tripico]

I already have an ODBC dirver established...
It's just that every month, there's a new table and I need the new table's info. The only possible way for me to link/ import the new table is to manually do it.

 

[Liv Manto]

Set up empty tables but are pre-linked... Go to tools, relationships..

Then feed those tables from your outside tables.

You have to create delete all, then insert into sqls.

 

[tripico]

These tables are not created yet so how will I linked these tables?
What I do know is that when month end approaches. a new table is create with a prefix "ITM" followed by the month number.

eg. ITM01 for January.

I'm looking for a way to have Access look for a say table 'ITM03'.
If it does not exist then create a link through the same ODBC setting and link to table 'ITM03'.

Hope that makes sense

 

[KeithG]

Couldn't you use Docmd.TransferDatabase to link the table