Linking to External Data

Top Previous Next

This software can link to columns in Microsoft® Access, Excel or a CSV text file as a data source for a text or barcode object, which allows printing of labels from data in Excel and Access or from a file export from other software. Perform the following to link to the data source:

1.	Choose Tools - Data Sets - Link External Data.

2.	Choose the data type and choose Search to find the file.

3.	After the source path is found, choose the appropriate table if applicable.

4.	Choose Link Data and there should be a portion of the linked data on the screen.

5.	After the data is linked, choose Close.

6.	To link a column of data to a barcode or text object, click the down arrow next to "Value Type" and select "External DataSource", and click on the source column to link the value. The example window will show what is linked.

7.	Increment the "label number" in the design screen to verify the data is linked.

8.	When printing, we suggest choosing "all rows data source" as the option, but only after printing a single page first to verify the alignment.

9.	When linking to the CSV or Text files, the format should be as follows: CSV: "Column1","Column2","Column3" TEXT: Column1,Column2,Column3 NOTE: fields containing numbers beginning with zero must be in CSV format and included in parenthesis.