RE: Replace existing records in a table

Tech-Archive recommends: Fix windows errors by optimizing your registry

Pani,

It may be more work than your deletes and appends, but it will be less work
than doing each change by hand.

Are you familiar with Update Queries? When you create an update query, you
identify the table and fields to be updated. You can choose all the fields
if needed. Then you identify the source (Update From), then you can identify
the criteria that determines whether a row in your table will be updated.
That is why I asked if there is a field or combination of fields that you can
compare to select the rows to be updated. It should be the same as the
primary key for the table.

"Pani" wrote:

> Klatuu, Thank you for your response. I had sent a reply earlier and the
> system did not take it so I am writting again. I think the update query would
> only help to modify existing records with one particular value we put in the
> update to field, right. However, my problem is, I have multiple fields that
> needs to be updated in the 15000 records database. I maintain all the change
> request sent to me by the customers in an excel format. and link it to Access
> and would like to perform something like a lookup to find the unique value in
> Access central db and find that in the excel file and if it is there then
> change/update all the field to mirror the field in excel. As you said, I
> might need a lot more good luck, before I get a solution.
>
> Thank you, await the solution with the help of the forum participant.
>
>
> --
> Pani
>
>
> "Klatuu" wrote:
>
> > Pani,
> >
> > It may not be as difficult as it seems. I would suggest you try using an
> > Update Query. You would have have a unique value in your Excel *** and
> > your Access table you can match on to make the replacements.
> >
> > Good Luck.
> >
> > "Pani" wrote:
> >
> > > Greetings from Pani. I would be very thankful if anyone can help me with my
> > > question. I am trying to maintain a central database for a list of
> > > responsibility centers that i have to maintain on a regular basis. For any
> > > delete and addition, I populate it in an excel tabel first and use link
> > > table and delete and append query to update my center table in Access.
> > > However for any changes that should go in the center table, is there any way
> > > I can still maintain an excel table, link it and use ????????(this is where i
> > > need help)...to implement find and replace function with a click of a button
> > > the way the delete and append query works. The replace would include many
> > > different values in different rows with in the central table.
> > > If there is a better way to address my concept of maintaining a central
> > > table, please provide so.I appreciate your help.
> > > I did all research, bougth a book in Access and finally am at your mercy.
.

Quantcast