Joins Across Servers/Databases

  • Thread starter Thread starter documenter
  • Start date Start date
D

documenter

Hi there,

Is there an easy way to use excel to create a single query that joins
two different databases, such as an oracle db and a MS SQL db, and
bring the data back into one excel worksheet.

This is a complicated task that I'm trying to accomplish, but have not
had any luck so far.

Thanks in advance
 
Did you try Data>Get External Data>New Database Query?

In the wizard, select a table and proceed to the last step. There, you can
select "View Data or Edit Query" option and view the Query Grid, wherein you
can add Tables, define relationships etc.

Regards,
Murthy
 
Back
Top