To get some columns of a db in an other db

[zubral]

Hello,

I have just a little question :
How to select a field from a database in an other
database ?
For instance, I would like to use the 3 first column of a
database in another one (for instance to have the first
and last name) and put in the other fields other things
than what is in the first database.

Thank you a lot in advance.

Zubral

 

[Jeff Boyce]

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.