Conditional Connection to Multiple Databases
Hello,
I have an excel workbook that contains multiple sheets. Is it possible to establish a query that would take input data, use this input data to form a database connection with one of the sheets, and fill the rest of the label with the data from the database?
Thank you!
0
-
Yes you can do that.
You would need to add each sheet individually and once you have added the second one a new Joining screen will appear and in that you will need to configure which field in table 1 holds the same data as what field in table 2 etc.
1
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
1 Kommentar