Add old info to a completely redesigned database

[Jesse]

Hi,

I have been using the same database for 3 years. This year, I have
completeley redesigned it in a brand new file. Is it possible to bring in
some old data into the new database? For example - names and addresses.
What if the fields have changed names?

What is this process called...synchronizing?

Thanks!
Jesse

 

[Duane Hookom]

You can either import the previous tables or link to them. You can then run
append queries or whatever to add the records from the old tables to the new
tables.

 

[Jesse]

Thanks...but let me clarify...

I have a table "Families 2004" with about 175 records.
I created a brand new table "Families 2005" with new/changed columns.

When I copy and paste it gives me an error because the columns don't match
up at all.

How do I transfer records from "Families 2004" into "Families 2005"?
I want to put Names/Addresses/Phonenumbers from the 2004 table into the 2005
one.

THANKS!
Jesse

 

[Jesse]

Thanks Duane! I didn't understand what an append query was at first but I
did some research and this is exactly what I needed! It works! Super cool!

Jesse

 

[Duane Hookom]

You might want to study up a bit on normalization. Having a year in a table
name isn't normally good practice.