71 70
IMPORTANT: The upsAddress table itself should
not be open when you go to import. Make sure
the table is closed but highlighted, then perform
the following steps:
(a) Select Get External Data from the File menu.
You should see two options when you select
Get External Data: “Import” and “Link Tables.”
Select Import as shown in Figure 22.
(b) Browse to find your address data (the file you
want to import). Make sure to change the
Files of Type drop-down list so that you can
see the appropriate files. For example, if your
data is in an Excel worksheet, the Files of
Type field should read “Microsoft Excel.”
Otherwise, you won’t be able to see any Excel
files.
(c) When you’ve found your address data,
highlight the file name by clicking it once, then
click Import. This will bring you into the
Access Import Wizard. (See Figure 23.)
Figure 21: Highlight the table named upsAddress before
importing.
Figure 20: Format your address data into columns with
these exact names.
Step 2: Import your data into the
upsAddress table
A table within the database named Exchange.mdb
controls the Address Book feature of
MASTERFORM. This database sits in your
MASTERFORM installation directory. By default,
the directory is C:\MF_UPS.
You must have Microsoft Access installed on your
computer to open and use the Exchange.mdb file.
If you have Microsoft Access, simply browse to
the installation directory (C:\MF_UPS) and
double-click the file Exchange.mdb.
Inside Exchange, click the Tables tab to find the
table named upsAddress. This is the table that
stores your address data. (See Figure 21.) Again,
it is configured with the following column names:
CompanyName, Address, City, State, Postal Code,
Contact, Phone
