G
Guest
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.
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.