Joins Across Servers/Databases

[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

 

[Ramana Murthy]

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