Joining Excel database with Oracle database 关注
Using Bartender designer 2016. Version is 126.96.36.19953 (64-bit).
I need to use an excel sheet with a list of container IDs and join to an Oracle database with info about those containers. I create the database connection for the excel and then add the new record set which uses an existing named database connection that I have working on other templates, using a custom SQL that I also know works on other templates.
When I go to Multi-database join the two, the left operand and the right operand both show the excel sheet name and fields only and neither shows the Oracle query fields. Any suggestions? Do I have to turn my query into a view so it only reads as one "table"?
I read some posts about problems with Excel but I can't find them again.