Linking a database to a template – Brother TD-2120N User Manual

Page 17

Advertising
background image

16

Linking a Database to a
Template

Label sample

A database can be linked to the template that
was created. Since the text in the template
can be replaced with text from the database,
multiple labels can be printed simply by
creating a single template.

For details on specifying database settings,
see [P-touch Editor Help].

a

Prepare a database file in advance.

NOTE

• Files saved as XLS, MDB, CSV and TXT

formats can be used as databases.

• In order to use files in the XLSX or ACCDB

format, Microsoft

®

Office 2007, 32-bit

Microsoft

®

Office 2010, 2007 Office

System Driver: Data Connectivity
Components, or 32-bit 2010 Office
System Driver: Data Connectivity
Components must be installed.

• Only one database can be linked to a

single template. A maximum of 65,000
records can be created in that database.
(The total size of templates and databases
is limited to 6 MB.)

• The data entered in the database can be

displayed on the LCD. Only the first 13
characters can be displayed.

b

In P-touch Editor 5.0, open the template
to be linked to the database.

c

On the menu bar, click [File] -
[Database] - [Connect] to display the
[Open Database] dialog box. Select
[Connect Database File], click
[Browse...], and then select the
database to be linked.

d

Click [Next] to display a settings dialog
box. With [Database Field] under
[Merge Fields], specify which database
column will be linked to which object,
and then click [OK].

e

The template and database will link, and
the main window appears. Click the
database row to be checked in order to
display the label with the text replaced.

Advertising
This manual is related to the following products: