<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2>Ed,</FONT></SPAN></DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=433281820-03102003><FONT face=Arial color=#0000ff
size=2>Rusty<BR></FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Tesiny, Ed
[mailto:EdTesiny@oasas.state.ny.us]<BR><B>Sent:</B> Friday, October 03, 2003
2:37 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Replacing a Table in an Application<BR><BR></FONT></DIV>
<DIV><SPAN class=292022819-03102003><FONT face=Arial size=2>Hi
List,</FONT></SPAN></DIV>
<DIV><SPAN class=292022819-03102003><FONT face=Arial size=2>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....</FONT></SPAN></DIV>
<DIV><SPAN class=292022819-03102003><FONT face=Arial
size=2>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=292022819-03102003><FONT face=Arial
size=2>Ed</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT size=1>Edward P. Tesiny</FONT></DIV>
<DIV align=left><FONT size=1>New York State OASAS</FONT></DIV>
<DIV align=left><FONT size=1>Evaluation and Program Monitoring</FONT></DIV>
<DIV align=left><FONT size=1>1450 Western Ave.</FONT></DIV>
<DIV align=left><FONT size=1>Albany, New York 12203-3526</FONT></DIV>
<DIV align=left><FONT size=1>Phone: (518) 485-7189</FONT></DIV>
<DIV align=left><FONT size=1>Fax: (518) 485-5769</FONT></DIV>
<DIV align=left><FONT size=1>EdTesiny@oasas.state.ny.us</FONT></DIV>
<DIV> </DIV></BODY></HTML>