How to Batch generate EAN14 bar codes using database import

2022-12-02 | 496 view
When large quantities of barcodes are generated, it is common to use the data object type "database import" to operate.

When large quantities of barcodes are generated, it is common to use the data object type "database import" to operate. Professional barcode software also supports a variety of database types, such as Excel files, text files, Access, MySQL, CSV files and so on. What type of database you choose should be based on your specific situation. One of the users use more Excel form files, the following Xiaobian with an example to specific operation.

Open the barcode label software, create a label, and set the label size according to the size of the label paper. Then import the database, click "Set data source", select Excel as the data source type, and click "Select File" to import the TXT file with EAN14 barcode data into the software as the database.

 

Click the [Barcode] button on the left of the software, draw a barcode on the label, select the barcode type as EAN14 in the pop-up editing interface, and select the field where the data source field is inserted.

 

After the bar code is made, set the font, size and color of the bar code text on the right side of the software according to your own needs.

 

Click [Print preview] to set the layout of paper and label. You can view the generated bar code by clicking the previous page and the next page. You can start printing after it is accurate.

 

To sum up, this is the method of batch generation of EAN-14 barcode in barcode software through database import. We only set 20 pieces of information in the database for example. If the database has many pieces of data, the number of bar codes will be generated.