Open topic with navigation

Importing Database Tables

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

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 Data Builder. 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.