Print with a Database Connected
The following example describes how to create the barcode labels below with Excel data. 1.Get the database ready in advance. 2.Open P-touch Editor. 3.From the Printer combo box, select your printer. 4.From the usage category, select the category to create (Asset Management in this example). 5.Select the template to create (Equipment Label 2 in this example). 6.Check the Connect Database check box in the upper left and then click . 7.In the database selection window, select Connect Database File and click the Browse button. 8.Select the prepared Excel file. Select an edit mode for the target database (Connect as read-only. in this example) and click the Next button. 9.Associate the text objects in the layout with the database fields. In Merge Fields:, associate each layout object with the relevant item in the database field. In this example, select Parts Name for "Name", Rorder No. for "Model Number", and Parts Code for "Bar Code". 10.Click the OK button. 11.The layout connected to the database appears. Print the label.
