[AccessD] Replacing a Table in an Application

Ed,
You can just delete the records from the existing table (without deleting
the table itself), then import the new records from the new table.  A simple
delete query will handle clearing out the old records.  As far as getting
the new records in, if you can link a table to the new data, an append query
will do the trick.
 
 
HTH
 
Rusty

-----Original Message-----
From: Tesiny, Ed [mailto:EdTesiny at oasas.state.ny.us]
Sent: Friday, October 03, 2003 2:37 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Replacing a Table in an Application


Hi List,
Quiet day, good time to ask what is probably a simple question.  I have a
table in an application that contains information about agency Executive
Directors, Program Directors, phone numbers, etc.  This table has a
relationship with other tables.  I would like to get an updated table every
month so the info stays current.  How does one go about replacing the old
table with the new one without deleting relationships and recreating them
after importing the updated table.  I know this must be a common task but
not sure how to accomplish this.  Any ideas late on a Friday afternoon....
TIA
Ed
 
Edward P. Tesiny
New York State OASAS
Evaluation and Program Monitoring
1450 Western Ave.
Albany, New York  12203-3526
Phone:  (518) 485-7189
Fax:  (518) 485-5769
EdTesiny at oasas.state.ny.us
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031003/6b032045/attachment-0001.html>