A Query to update a Table

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

Hi,
I have a query in one database which I want to link to a
table in another database. Is it possible? Please advise.
 
You could use a make table query to create a new table, create a Primary Key
on the new table that relates to the primary key of the original table and
link the tables that way.

If you just want to update the original table with the contents of the query
just make the query an append query.
 
Back
Top