Link old and new databases or Import?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top