# Joining Excel with Oracle Tables **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [March 29, 2018, 8:08am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777 "2018-03-29T08:08:26Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Patrick\_Kipp](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@Patrick\_Kipp](https://forums.toadworld.com/u/Patrick_Kipp)\ **Post date:** [March 29, 2018, 8:08am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/1 "2018-03-29T08:08:26Z")
Hi i´m Patrick from Germany and i have troubles in joining tables from an Excel Connection with the tables from our company in the Oracle databases. First i managed to solve the problems regarding the use of a 32-bit Office and the needed drivers for 64-bit Office to import or connect Excel tabele, e.g. I now establishe a new excel connection with a table and followed the solution from this thread [https://community.toadworld.com/products/toad-data-point/f/36/t/6472](https://community.toadworld.com/products/toad-data-point/f/36/t/6472) I can drag the Excel table into the Query Builder but i am not able to drag the Oracle table as well. Nothing happens after dragging. Somebody could help? Greetings Patrick ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [April 2, 2018, 10:46am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/2 "2018-04-02T10:46:39Z")
Heterogeneous queries are supported in the Professional edition of Toad Data Point, so make sure you’re using that edition ( **Help | Licensing** from the main menu). Secondly, is the Oracle table not displayed in the query builder? With the Query Builder as the focused doc tab, try double-clicking on the Oracle table within the Object Explorer. This is an alternative way to populate the query builder with objects/tables. If the Oracle table does not display, either by dragging/dropping it onto the Query Builder, or double-clicking the object within the Object Explorer, then there’s likely something wrong which would warrant a call to our Support Group. Regards. ---
**Author:** ![RibbitFan](https://avatars.discourse-cdn.com/v4/letter/r/a9a28c/32.png) [@RibbitFan](https://forums.toadworld.com/u/RibbitFan)\ **Post date:** [April 2, 2018, 10:52am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/3 "2018-04-02T10:52:12Z")
Make sure, too, that the schema owner is correctly filtered as the tables appear under a user. **From:** Gary.Jerep [bounce-GaryJerep@toadworld.com](mailto:bounce-GaryJerep@toadworld.com) **Sent:** Monday, April 2, 2018 12:48 PM **To:** [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com) **Subject:** RE: [Toad Data Point - Discussion Forum] Joining Excel with Oracle Tables **[RE: Joining Excel with Oracle Tables](https://community.toadworld.com/products/toad-data-point/f/36/p/35190/70082#70082)** Reply by Gary.Jerep Heterogeneous queries are supported in the Professional edition of Toad Data Point, so make sure you’re using that edition ( **Help | Licensing** from the main menu). Secondly, is the Oracle table not displayed in the query builder? With the Query Builder as the focused doc tab, try double-clicking on the Oracle table within the Object Explorer. This is an alternative way to populate the query builder with objects/tables. If the Oracle table does not display, either by dragging/dropping it onto the Query Builder, or double-clicking the object within the Object Explorer, then there’s likely something wrong which would warrant a call to our Support Group. Regards. To reply, please reply-all to this email. [Stop receiving emails](https://community.toadworld.com/products/toad-data-point/f/36/t/35190?subscribe=false) on this subject. Or [ Unsubscribe from Toad Data Point Forum](https://community.toadworld.com/products/toad-data-point/f/36?subscribe=false) notifications altogether. Toad Data Point - Discussion Forum [Flag](https://community.toadworld.com/products/toad-data-point/f/36/p/35190/70082?AbuseContentId=7a11c260-0b90-4616-8b2b-47482b80b74d&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. [Click here for Anadarko’s Electronic Mail Disclaimer](http://www.anadarko.com/notices/Pages/Electronic-Mail-Disclaimer.aspx) ---
**Author:** ![Patrick\_Kipp](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@Patrick\_Kipp](https://forums.toadworld.com/u/Patrick_Kipp)\ **Post date:** [April 3, 2018, 4:06am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/4 "2018-04-03T04:06:09Z")
Hi Gary, i guess that i have the standard version. So i try to get the professional version first. Thanks for your help so far. If there is another workaround, e.g. importing the excel table or something else, than i would be very thankful for this information. Greetings, Patrick ---
**Author:** ![Patrick\_Kipp](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@Patrick\_Kipp](https://forums.toadworld.com/u/Patrick_Kipp)\ **Post date:** [April 3, 2018, 4:14am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/5 "2018-04-03T04:14:36Z")
> [@](#): > > Heterogeneous queries are supported in the Professional edition of Toad Data Point, so make sure you're using that edition ( **Help | Licensing** from the main menu). > > Secondly, is the Oracle table not displayed in the query builder? With the Query Builder as the focused doc tab, try double-clicking on the Oracle table within the Object Explorer. This is an alternative way to populate the query builder with objects/tables. > > If the Oracle table does not display, either by dragging/dropping it onto the Query Builder, or double-clicking the object within the Object Explorer, then there's likely something wrong which would warrant a call to our Support Group. > > Regards. Hi Gary, thank you for your help. I guess that I#m using the satndard version, so I try to get another version first. I now have TOAD Data Point (Edition TOAD Data Point)and i could get TOAD Expert or TOAD Standard. Which one should I choose? If there is anything else I colud do to solve my problems, e.g. any workarounds, please let me know. Greetings, Patrick ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [April 3, 2018, 8:36am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/6 "2018-04-03T08:36:51Z")
Yes, download the Professional Edition of Toad DataPoint. You’ll like that you’ll not only be able to blend different data sources, but there are other valuable capabilities like visualization, data profiling, transformation & cleanse, and other features. You do mention a work-around, which is to import your Excel data to an Oracle table, and then join that table with the others on your Oracle environment. ---
**Author:** ![Patrick\_Kipp](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@Patrick\_Kipp](https://forums.toadworld.com/u/Patrick_Kipp)\ **Post date:** [April 4, 2018, 4:57am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/7 "2018-04-04T04:57:41Z")
> [@](#): > > Yes, download the Professional Edition of Toad DataPoint. You'll like that you'll not only be able to blend different data sources, but there are other valuable capabilities like visualization, data profiling, transformation & cleanse, and other features. > > You do mention a work-around, which is to import your Excel data to an Oracle table, and then join that table with the others on your Oracle environment. Is there a download link for a trial version of the professional edition. I only find a download option for Toad Data Point without specification if it´s the normal or the professional edition. In our companxy we only have Toad Data Point or maybe Toad Xpert. Will Toad Xpert match my needs? The workaround will not do it for me, because I'm not allowed to create tables in the oracle db (read only). Sincerly, Patrick ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [April 4, 2018, 8:59am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/8 "2018-04-04T08:59:23Z")
Sorry, Patrick, I should have included this link ( [https://www.quest.com/register/54955/](https://www.quest.com/register/54955/) ) where you can download the Toad Data Point trial. The trial flavor is Professional Edition and will give you the blending capability you need and more. Good luck, and let us know how it goes. ---
**Author:** ![Patrick\_Kipp](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@Patrick\_Kipp](https://forums.toadworld.com/u/Patrick_Kipp)\ **Post date:** [April 5, 2018, 4:35am UTC](https://forums.toadworld.com/t/joining-excel-with-oracle-tables/40777/9 "2018-04-05T04:35:24Z")
> [@](#): > > Sorry, Patrick, I should have included this link ( [https://www.quest.com/register/54955/](https://www.quest.com/register/54955/) ) where you can download the Toad Data Point trial. The trial flavor is Professional Edition and will give you the blending capability you need and more. > > Good luck, and let us know how it goes. Hi Gary, thank you! I will ask our system department for the installation and give you a feedback if my problem has been solved.