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

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.

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.

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