Re: To get some columns of a db in an other db

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 06:41:58 -0700

Zubral

Open the destination database.

Link to the database with the fields you wish.

Create a query on the table with the 3 columns, returning only what you
wish.

Change the query to an append query, and append the results to your
destination table (this requires that your destination table have three
fields into which you will append).

If you aren't just adding records, but updating existing records, use an
update query instead of an append query. 

-- 
Good luck
Jeff Boyce
<Access MVP>