importing data in Access (and replacing exisiting data)

[biff]

Can you import data into an access database and have it overwrite/update
certain fields in the existing database with data from the file you are
importing?

Is there a way to choose which fields it should update and how to match the
uploaded data to the correct record?

 

[Dorian]

No.
You can either replace the data in an existing table or append the new data
to the end of an existing table.
To do what you want, you would import the data to a new table and then write
an update routine to merge/update the other table. Possibly you could do it
with a query if it was fairly simple.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[pietlinden]

Can you import data into an access database and have it overwrite/update
certain fields in the existing database with data from the file you are
importing?

Is there a way to choose which fields it should update and how to match the
uploaded data to the correct record?

I think Danny Lesandrini has code that does this on his website.
www.amazecreations.com/datafast

If you link to the data file containing the new data,
you can create a query joining the two tables on the primary key field
(s) and then create an update query to update the new values. Then if
you use the find unmatched query wizard, you can import the records
that are not already in the table.