I am seeking help in joining an excel file to a table that is native to my database schema, and generate a query result set. Please let me know if you have any suggestions.
If you have Toad Data Point Pro you can use Cross-Connection Query to join any disparate databases. See the help file or these videos.
https://www.toadworld.com/products/toad-data-point/m/media-library/1319
https://www.toadworld.com/products/toad-data-point/m/media-library/1317
Hi Debbie,
I am writing because of your reply to this post from about 2.5 years ago. It has links that supposedly lead to videos that show how to write and execute a Cross-Connection Query. However, the links don't go to specific videos any longer.
Can you update the links or provide updated information to me?
Thanks!
Patrick C. Rowe