Append Query for upgrades?

E

Ed

Hi All: Using Wxp, Axp. I have a split database with a dozen or so tables.
Each year or so I upgrade the database (front and back) with new ideas
including fields in tables etc.. ,. After making changes and upgrading my
computer i need to perform the same upgrade on another computer. Heres the
question:
Is it possible to set up a series of append queries to take data from old
database and append the data to the new database where fields match?
Any places to get specific info on distributing upgrades with the concern of
importing old data? Or is it better to copy table data and paste?
Thanks, Ed
 
Top