Query from two databases into Excel

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

I have two separate databases that have a common field of CustNo. I'll like
to run a query in excel using Get External Data... whereby I could create a
report that brings in data from both the databases.

Having tried this in Excel, it seems that I can only use one table at a
time, is there a way to overcome the issue.

Thanks, Rob
 
Back
Top