update query

[Guest]

I am not sure how an update query works. I have a table named Downinfo that
is my primary table. I have three fields named CDCnum, InmateName, and
InmateHousing. How can I make an update query to import from a txt file and
have the query make changes in the InmateHousing field of the table? I need
to compare the old with the new information, delete any records that are no
longer at the institution, as well as include any new CDCnum, InmateNames and
InmateHousing that are not on the current table. Any advice would more than
welcome.


A little help please

 

[Guest]

Hi Ducat,

I need to compare the old with the new information, delete any records that
are no longer at the institution, as well as include any new CDCnum,
InmateNames and InmateHousing that are not on the current table.

Are you telling us that your text file includes all of the current data? If
the answer is yes, then you may just want to run a delete query to clear the
table of all records, followed by an append (not update) query to add records
from a linked text file. This should work okay as long as you do not have any
related child tables.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[tina]

also posted, and answered, in microsoft.public.access.modulesdaovba
newsgroup. please don't multi-post. see
http://home.att.net/~california.db/tips.html#aTip10 for more information.