easy deletion of table contents

[tammy.n.turner]

i've been searching for an easy way to delete most of the content of
my table but preserve the structure. you know other than highlighting
each cell and then the delete key?? i would like to preserve the first
two columns, i'll be using the same info this time around, but the 4
other columns will be new information.

i thought there was a 'delete' content choice, but that may be some
other software in another cubicle hell i've lived! anyway, if i have
to delete all the content, so be it. that i think i can do very easily
and still keep the structure and links.

okay, thanks in advance for any help.
t.

 

[Douglas J. Steele]

I have a hard time envisioning why you'd want to keep some of the data in a
table, but not the rest (it sounds like your database design may not be as
good as it could be), but you can either delete the fields you don't need,
or you can run an Update query to set the field's value to Null (or
whatever's appropriate)

 

[mray29]

One simple way is to create an update query. Set the Update To.. values for
the columns you want to empty to Null (assuming those columns allow a null
value).

 

[tammy.n.turner]

I have a hard time envisioning why you'd want to keep some of the data in a
table, but not the rest (it sounds like your database design may not be as
good as it could be), but you can either delete the fields you don't need,
or you can run an Update query to set the field's value to Null (or
whatever's appropriate)

First off, thank you I didn't think about a query (duh!) but that will
work out great! And just for edification, we're reusing this database
for a similar project. So I copied it to a new location, double-
checked that they weren't linked in any way, and now I'm going to
delete the data in the tables so we can start anew!
Thanks again. This is a big time saver.
t.
(please no e-mails. the state frowns upon them!)