Query from two or more mdb files

[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

 

[Peter R. Fletcher]

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

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

 

[Rob]

Peter,

Thanks for the reply, works a treat. Rob