I have a very old file that accepted and prints out a list of ten names, addresses and phone numbers on a single sheet of paper. This was developed by creating 10 first name fields (first name 1, first name 2, etc) and ten last name fields, etc. I have since created a more typical file in which one name, address, phone field is used and a new record is created for each person. Here is the question. Is there a script that can be created to transfer or import the old data of ten records on one sheet with different field names into the new data base? By using the same field names in the new file I can only import, of course, just the first person because the remaining 9 sets of fields in the old file do not match up with the field names in the new file. Any suggestions? Thanks.

Bob Sherman

You could try exporting to Excel, then import from Excel into your new DB.

Ed

You can do ten imports from the old file into the new one. Just change the import order each time so that you are importing from the next set of fields.