Moving fields to new table

[dgmorr]

Hey guys,

I'm trying to move a group of fields to a new table. I want the data to follow it. Is there an easy way to do this?

 

[namliam]

Copy the table or use an Update query...

 

[dgmorr]

Copy the table or use an Update query...

I have a large number of fields, is there a way that I don't have to type every single thing out? I'm putting old fields from a few tables into one table called ARCHIVE

 

[GaryPanic]

append ????

 

[namliam]

use the query designer to drag the fields and copy the sql?

 

[GaryPanic]

open the source table in design mode highlight the fields you want
go to archive (design mode) and paste
now append from source table these fields to archive table it should pick these out automatically

as a point
copy both databases onto a local pc -change the link to the local versions don't do it over a network
check it then repalce the archive