I have two databases one with the same names as the other database. I would like to merge database1 into database2, but I only have some of the fields in one and not the other.

Do I create the feilds first? Is there an easy way to do this? You see I also need record "John Smith" to stay in the same place.

Thanks,

RET

It depends.

I'd suggest first deciding which database will remain. In this database create all the necessary fields -- make doubly sure the names are identical in both databases. Then perform the import by matching the field names.

Depending on what was in the databases, you might then need to search for duplicate records and delete the extras. Again depending, you may need to "merge" the data in the duplicate records before deleting the extras. No, there is no magic way of "merging" the field data (hence tyhe term in quotes) the most fool-proof way is to check them manually by eye and decide yourself.