Importing data

[Schrambow]

Hello,

I have two databases (pricing databases) which were identical 2 years ago. (has price breakdowns for different quanities of a product). One database (database a) is current in these fields the other is not (database :. However i have a lot of linked pictures in database b and don't want to loose these. Therefore, what type of script could i do to take the pricing data from (database a), and bring it into (database : without deleteing the current container fields. There are probably alot of new records that were created in database a, that are not in database b. Any help would be greatly appretiated.

Thanks

Corey

[Steve T.]

HI, Corey! Unless you plan on doing so a few times, I would not bother scripting it. First, make copies of both db's just in case, and then import all your data from A into B using IMPORT RECORDS under the FILE menu. You should get an option to map fields, set a key/match field, replace existing data, and decide what to do with non-matching (new) record data. This assumes you have some kind of unique id number per record, though... if not, you may have to do multiple sorts/imports/exports to be sure you get them all and in the correct order.

Hope this helps!

--ST