Hi there,

I have a bit of a dilemma here.

I have an old database, which is very comprehensive, filled with client names, addresses, and other information.

I have been given a new database, which is more relational and effectient, which splits the client addresses into a seperate table.

I need to add the old data to the new database - so is there a way of doing this whilst maintaining the links between the old addresses and the rest of the old data? What I don't want to have to do is end up going through 3000+ entries sorting out what new CompanyID I should assign...

Any thoughts?

Cheers

Hob

you probably need a field in the new database for "old reference". then you can add the data into the table with the old references, and ignore the new references temporarily

having done this, do an update query to link on the old references, but set the new references.

now it should all be linked ok, and you dont need the old references any more.

you probably need a field in the new database for "old reference". then you can add the data into the table with the old references, and ignore the new references temporarily

having done this, do an update query to link on the old references, but set the new references.

now it should all be linked ok, and you dont need the old references any more.

OK, cheers :)