Update table fields

[chefdaveross]

What is the best way for me to update a table from a different file based off the same table with new fields
Have old tables on different databases that I would like to update with new fileds while keeping the old data.
It doesnt look like I can import specific fields into a table from import external data.

Thank you

 

[SOS]

You can import specific field data, but it depends on what it is that you are using to import from as to how you can do it.

 

[MSAccessRookie]

What is the best way for me to update a table from a different file based off the same table with new fields
Have old tables on different databases that I would like to update with new fileds while keeping the old data.
It doesnt look like I can import specific fields into a table from import external data.

Thank you

Perhaps you could import the data to a Temporary Table and then do the update using an Access Update Query. That should gove you total control of which fields are updated with which values.

 

[chefdaveross]

thanks for the replys,
im setting up some append queries now
kind of tedious but getting the job done