Open topic with navigation

Importing and Exporting Data Tables

You can import a data table from an external file or relational database into a Data Builder database. 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.

You can also export the content of a data table to a file in comma-separated value (CSV) format.

ClosedTo import a data table

  1. In the Tables pane, select an existing data table.

  2. On the Home tab, click Import, and then click Data Table. Alternatively, in the Tables pane on either the Home or Fields tab, right-click an existing table, and then click Import Data Table.

  3. Follow the steps in the import wizard to select the data table that you want to import.

ClosedTo export a table to a CSV file

  1. On the ribbon, click Export, and then click Export CSV. Alternatively, in the Tables pane, right-click the table name, and then click Export CSV.

  2. In the Export to CSV dialog, browse to the location that you want to export the file to, enter a file name, and then click Save.