Connect a Database and Create a Database Field

This software contains powerful connectivity tools that let you merge information from Microsoft Access, Microsoft Excel, Microsoft SQL Server, Oracle, the general OLE DB Provider, ODBC or a text file.

To create a field with information from a database you must first connect to the database. You can do this by specifying the database path and describing some of its properties. You can then add a database field to your label.

The Data Sources panel in the toolbox lists all connected databases.

To connect a database:

• • 1. Click the Database Setup icon   on the toolbar.

    2. Click the Add button in the Database Connection panel.

    3. Select the type of database to add and follow the wizard directions.

    4. When you have connected the database, view records by highlighting a table and clicking the View Records tab. The database appears in the Data Sources pane.

To add a database field to a label:

• • 1. Follow the above steps to connect a database.

    2. Click the plus sign next to the database name to display tables and fields.

    3. Select a field and drag it to position it on the label. A menu appears.

    4. Select Create Text, Create Barcode, or Create Picture.

       NOTE: To modify properties for the field, right click on it and select Properties.

Related Topics