Toad World® Forums

Join schema native table with excel file

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

http://www.toadworld.com/products/toad-data-point/b/weblog/archive/2012/11/21/how-to-write-a-cross-database-query

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