update tbl fields from imported data..

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

Guest

does anyone have a template for updating table field from imported data..from
my procedural based knowledge, i assume looping thru imported data table,
then 'update' other table based on key.. or is there sql/query setup that
does this simpler?
thx!
 
I would just build an update query. Would depend on what your data looks
like, if there is a key field to identify records, etc.

Rick B
 
does anyone have a template for updating table field from imported data..from
my procedural based knowledge, i assume looping thru imported data table,
then 'update' other table based on key.. or is there sql/query setup that
does this simpler?
thx!
Click to expand...

An Update query is the preferred solution. No looping and (unless
you're launching the query from code) no code is needed at all.

Create a Query joining the imported table to the local table by the
key field. Change it to an Update query using the Query menu option or
the query type icon. On the "Update To" line under the field that you
want to update, enter

[ImportedTableName].[FieldName]

using your names of course.

Run the query, by clicking the ! icon or by executing it from VBA.


John W. Vinson[MVP]
 
Back
Top