Excel query from Access databases

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

Rob

Hi,

I have two separate databases in Access 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
 
Hi Rob-

"I have two separate databases in Access that have a common field of
CustNo."

Is that accurate or do you mean 2 separate Tables in 1 Access DB file which
use CustNo as the common field?

AFAIK you can only query one Access file at a time and only one Record
Source at a time from that file. The _Record Source_, however, does *not*
have to be a Table.

One idea:

(If 2 separate DB _Files_) In either of the DB files create a Link to the
Table in the other DB. Establish a Query Join (not a Relationship) using the
common field you refer to as a part of a Query in the DB where the Link is.

(If 2 _Tables_ in the same file) You can probably just make the Access query
as the tables are most likely related already with CustNo as the common
field.

Then use Excel to query that DB and use the Access query as the record
source.

You may also be able to work from within Access and Export the data found by
the Access query to an Excel file as another option.

HTH |:>)


Hi,

I have two separate databases in Access 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
Click to expand...

-- (e-mail address removed)
 
Thanks for the reply, the data is in 2 separate Access mdb files. I will
try to create the link in Access and from within Access export the info.

Thanks again for the ideas. Rob
 
Back
Top