Query from two or more mdb files

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

Rob

Hi,

I need to query data from two Access.mdb files that have a common CustNo.
field. The tables that hold the info are in separate mdb files and I can't
seem to find an option to create a query and save it whereby the data is
pulled from the different mdb files.

A previous post suggested to Link the files but if this is the option, how's
it done.

Thanks, Rob
 
From the Tables view: New|Link Table!!

Hi,

I need to query data from two Access.mdb files that have a common CustNo.
field. The tables that hold the info are in separate mdb files and I can't
seem to find an option to create a query and save it whereby the data is
pulled from the different mdb files.

A previous post suggested to Link the files but if this is the option, how's
it done.

Thanks, Rob
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top