update syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what is the correct way to update a table with data from another table in
another database. I have a table which is missing information. This
information is held in another database (which I dont want to link) and I
want to import the fields in to the current database. If I use an update
query how so I represent the foreign database field eg is it
[databasename]![databasefield] or [databasename].[databasefield] or am I
barking up the wrong tree?
Is an update query the correct thing to use?
 
I am being daft, but I already have the tables holding the data linked. What
do I put in the Updateto line in the query?

Rick B said:
Just create a link to the foreign table, run your update query, then delete
the link.

--
Rick B



lynn atkinson said:
what is the correct way to update a table with data from another table in
another database. I have a table which is missing information. This
information is held in another database (which I dont want to link) and I
want to import the fields in to the current database. If I use an update
query how so I represent the foreign database field eg is it
[databasename]![databasefield] or [databasename].[databasefield] or am I
barking up the wrong tree?
Is an update query the correct thing to use?
Click to expand...
Click to expand...
 
Depends on what you want to update.

You should select the table from the drop down and enter the field that
includes the data you want updated.

You might need to give us some specific details (field names, table names,
links, etc.)


--
Rick B



lynn atkinson said:
I am being daft, but I already have the tables holding the data linked.
What
do I put in the Updateto line in the query?

Rick B said:
Just create a link to the foreign table, run your update query, then
delete
the link.

--
Rick B



lynn atkinson said:
what is the correct way to update a table with data from another table
in
another database. I have a table which is missing information. This
information is held in another database (which I dont want to link) and
I
want to import the fields in to the current database. If I use an
update
query how so I represent the foreign database field eg is it
[databasename]![databasefield] or [databasename].[databasefield] or am
I
barking up the wrong tree?
Is an update query the correct thing to use?
Click to expand...
Click to expand...
Click to expand...
 
what is the correct way to update a table with data from another table in
another database. I have a table which is missing information. This
information is held in another database (which I dont want to link) and I
want to import the fields in to the current database. If I use an update
query how so I represent the foreign database field eg is it
[databasename]![databasefield] or [databasename].[databasefield] or am I
barking up the wrong tree?
Is an update query the correct thing to use?
Click to expand...

An update query updates *existing records*. It sounds like you want to
add new records that are present in the other database but missing in
yours. If so, the appropriate tool is an Append query, not an Update
query.

One question: if you don't link to the other database in some manner,
how can you get any data from it??

John W. Vinson[MVP]
 
Back
Top