Link old and new databases or Import?

[Guest]

Hi,
I have designed a new database which only contains Tables at the moment. I
have manually imported some Employee data from the current db to play around
with. This was quite cumbersome as the new db is normalised with Employee
data in 4 tables but the old db has all the information contained in just 1
table.

Before I start on queries, forms, reports etc. I would like to link/import
the current data from the old db to the new one. Which is the best way to do
this?

Thanks.

 

[Jeff L]

Click File, Get External Data, Link Tables. Navigate to your old DB
and select it. You'll get a window that opens and you can select the
tables you want to link to.

 

[Jeff L]

Click File, Get External Data, Link Tables. Navigate to your old DB
and select it. You'll get a window that opens and you can select the
tables you want to link to.

 

[Jeff L]

Click File, Get External Data, Link Tables. Navigate to your old DB
and select it. You'll get a window that opens and you can select the
tables you want to link to.

 

[Guest]

That part works fine, I think I now need to use an 'append' query to transfer
this linked data into the relevant tables/fields and then use an 'update'
query to keep it all up to date.

Any helpful URL's out there?

Thanks.