I'm slightly confused on the requirement that you have.
Would joining or union-ing the data be a possibility to solve this issue?
thank you for your answer and sorry for confusing
I have different connections in kind of queries on this database-file.
In one query I use 4 tables and a Excel-file (relationship on one of this selected mdb-tables).
In one other query I use 3 other tables of this mdb-file and this Excel-file (also with a relationship on one of this tables)
an so on...
if I want to analyse data from an other company, the Access-files and the Excel-file must be changed to get the other results.
So the querstion is, how to change ALL links on the access-file and the excel-file of the different connections in all this workbook at once.