75 74
Exporting addresses from the
Address Book
You can easily export the address data used in
MASTERFORM for UPS to a new Excel file or
Access database. MASTERFORM stores addresses
inside the database named Exchange.mdb, which
sits in the install directory (C:\MF_UPS by
default).
To export addresses from MASTERFORM:
1. Open Exchange.mdb in Microsoft Access 97 or
2000.
2. Highlight the table upsAddress by clicking
once.
3. Choose Save As/Export from the File menu.
Figure 25: Choose Save As/Export from the File menu
inside Microsoft Access.
(e) Click Next to continue.
(f) Confirm that the Import to Table field reads
“upsAddress,” then click Finish. Access will
pull your data into MASTERFORM for UPS.
Open MASTERFORM and make sure your
address data is there.
If you encounter any errors during the import
process, double-check your steps. Make sure the
upsAddress table is not open and your columns
are named correctly, then try again.
