Conditional Connection to Multiple Databases

Jozarek

• July 16, 2024 20:03

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

• 

  Peter Thane

  ★ BarTender Hero ★

  • July 17, 2024 10:02

  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

Please sign in to leave a comment.