update query

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

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/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"ducat assignment" wrote:

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

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.


"ducat assignment" wrote in
message ...
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

Hey Tom

Thanks for the response

The txt file has all the current information regarding all the inmates
currently housed here. The problem is most of the extra data is not used in
my database, if fact I only need CDCnum, InmateName and InmateHousing (3
columns out of about 15 columns of data). How can I get access to delete the
unwanted and any duplicate data. After that I need to either append or
update the tblDowninfo.

Thanks for your advise

"Tom Wickerath" wrote:

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/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"ducat assignment" wrote:

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