I am trying to create a cross connection query for two excel data souces. In the query builder if I drag and drop a table from one Excel data source, I am not able to add another table from the second excel data source.
Please let me know how to enable this feature. I am using the Toad Data Point 3.4 base edition.
In the base edition you cannot join more than one Excel file. For Cross Query in Base we use an Access database and this is a Microsoft limitation. In our Pro version we wrote our own Cross-Query optimizer and we can handle joining two excel files.
What version are you using? In TDP 3.4 we discontinued the support for Cross-Query in the base edition. You can enable it by selecting the “Alow Heterogeneous queries using Jet engine”. We don’t support it because it is not up to production work. Some people do use it and that is why we didn’t take it out of the product.