Open topic with navigation

Importing Database Tables

You can import a database table from an external file or relational database into a table in the Embedded Data Table Editor. All database types that are supported in BarTender are also supported for import into the editor.

Importing database tables is not supported when you access the editor by clicking Edit Data on the List Items property page for a data entry control.

If the database that you are importing includes multiple pages or tables of data, and if you import all the pages or tables at one time, they are concatenated into one table in the Embedded Data Table Editor. For example, when you import all the worksheets of a Microsoft Excel workbook that has multiple worksheets, the result is one table that contains the data in all of the worksheets.

To keep each page, sheet, or table that you want to import in separate tables, use the import feature separately for each.

ClosedTo import a database table

  1. In the Tables pane on either the Home tab or the Fields tab, use the secondary mouse button to click an existing table, and then click Import. The Import Table wizard starts.

  2. Follow the steps in the wizard to select the database that you want to import.