Linked Tables

[sammyd1978]

Can anybody help.

We have a computer system that uses ODBC files to export/updates information in access. To update these files you have to clilck refresh but I have at least 5 files which as you can imagine is quite time consuming. Is there any way to set a procedure to do this automatically?

 

[ReAn]

If all the tables you need from the ODBC have the same structure you can link them all at once. Then make an SQL Union Query that ports into a maketable query.

Union SQL:

SELECT * FROM tblOne
UNION
SELECT * FROM tblTwo
UNION
...

and so on...