Open topic with navigation

Importing and Exporting Data Tables

You can import a data 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.

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.

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.

    The Import Table wizard starts.

  3. Follow the steps in the 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 an existing table, 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.