Joining Excel database with Oracle database 关注

0
Avatar
Dianne Mays

Using Bartender designer 2016. Version is 11.0.8.3153 (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.

1 评论

0
Avatar
Dianne Mays
评论操作 固定链接

I seem to have answered my own question.  I put the query in a view and can now join the two databases.

请先登录再写评论。