importing cleaned contacts into database
Hi. We are working with File Maker Pro 9.0v3 on Mac OSX 10.4.11.
We have an xls file of about 2,000 contacts that we have had 'cleaned' (checked with the post office) and these contacts have new addresses. We need to find a way to have FMP automatically move the existing address to the 'address notes' field we have (we would still like to keep their old address in this field), preceded by 'old add:', and then import the new address into the address field. We are not total experts at this, and would not be able to write our own code. Is there an easy way to do this automatically, or does FMP provide a service for doing this type of thing?
Our databse is over a network, not onine.