# How do you link an Excel named range to an Oracle table?

**URL:** <https://forums.toadworld.com/t/how-do-you-link-an-excel-named-range-to-an-oracle-table/7137>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [March 2, 2012, 11:59am UTC](https://forums.toadworld.com/t/how-do-you-link-an-excel-named-range-to-an-oracle-table/7137 "2012-03-02T11:59:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBurks](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@SBurks](https://forums.toadworld.com/u/SBurks)\
**Post date:** [March 2, 2012, 11:59am UTC](https://forums.toadworld.com/t/how-do-you-link-an-excel-named-range-to-an-oracle-table/7137/1 "2012-03-02T11:59:57Z")

</div>

Everytime that I import an excel file and join it with any oracle table I alwasy get the following error message.

[Microsoft][ODBC Excel Driver] Reserved error (-7778); there is no message for this error.

Is there a rule of thumb on how to connect with multiple databases?

Thanks - Shaun

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [March 2, 2012, 4:06pm UTC](https://forums.toadworld.com/t/how-do-you-link-an-excel-named-range-to-an-oracle-table/7137/2 "2012-03-02T16:06:33Z")

</div>

That is a general error that is given by Access. We use Access in the base edition to do cross-queries. It is not very robust. Please dowload the Beta and give cross-query a try there.

[http://tda.inside.quest.com/beta.jspa](http://tda.inside.quest.com/beta.jspa)

Debbie