User Manual

40
2 On the Insert menu click Row or click as many times as
necessary to increase the number of rows to that required for all of
the data records you plan to input.
3 On the Insert menu click Column or as many times as
necessary to increase the number of columns to that required for all
of the items in each data record.
4 To change a column title, click its current title (Item1, Item2, etc.) and
then input the desired name into the Item Name box.
Data box
Item Name box
Item name columns
5 To input data, click a cell and then input into the Data box.
Important!
Data cannot be input directly into a cell. Select a cell and then input the
data into the Data box.
6 Repeat steps 4 and 5 as many time as necessary to input all of the
required item names and data.
7 After you fi nish creating the data, click Update on the File menu.
8 On the File menu, click Exit Merge Database.
This exits Merge Database Tool.
Importing Other Software Data into a Merge Database
You can use the procedure below to import data create with other
software and create a merge database.
Important!
The fi le formats below are supported for merge data import.
.txt .csv .xls .xlsx
To import data from an Excel fi le, you will need to have one of the
following Microsoft Excel versions installed on your computer: 2000,
2002, 2003, 2007, 2010, and 2013.
1 Click Import on the File menu, or click the icon.
This displays the Open File screen.
2 Specify the name of the fi le that contains the data you want to
import.
3 Click Open.
If you specifi ed a txt or csv data fi le, a Text Data Format screen
will appear. If you specifi ed an xls or xlsx data fi le, a Select Sheet
screen will appear. If no screen appears, go directly to step 6 of
this procedure
Excel File Import Precaution
The maximum size supported for Excel fi le import is 1,024 rows x
128 columns.
4 Confi gure the Text Data Format or Select Sheet settings as
required.
•
•
•
•
•
•