In Exportizer, you have several ways to import data into your target database.

1. Export Data

Data importing works similarly to exporting, where the source and the target are swapped. So, just open your source database and then export data to the target database using Database target format.

Note: This method is available in Exportizer and Exportizer Pro.

2. Drag Folders and Files from Windows Explorer

If your source data comes from folders and/or files, just select them in the Explorer and drag and drop them into Exportizer with open target database. Note: The same functionality is available by choosing Import | Import Database Files... menu.

In Exportizer and Exportizer Pro, the first selected item will be opened as a data source. If there was an open database before, it will be closed.

In Exportizer Enterprise, Import Files dialog will appear where you choose what to do with selected folders and files. This dialog has several parts:

List of files / folders to import

Here, you can review what the application is going to import. You can deselect items mistakenly selected.

Action to perform

You can choose what to do with selected files and folders:

In a step-by-step example, you can see how Exportizer imports different kinds of dragged database files.

3. Paste Tabular Data from Clipboard

If your clipboard contains some tabular data (e.g. copied from Excel etc.), you can paste it into a table opened in Exportizer. Use Ctrl+Alt+V combination or Paste Cells From Clipboard item from Tools menu or from context menu of the data grid.

Note: If you need to append clipboard data to destination table which is not empty, you need some preparation. First, locate the last record in the table, then press down arrow key: this switches the dataset into Append mode and creates a blank row in the data grid. Then select the needed cell in the new row and press Ctrl+Alt+V.

4. Import Any Data from Clipboard

This method looks similar to the previous one (pasting data from clipboard), but is much more powerful. It has the following benefits:

Of course, to use all the benefits, the data require some preparation. The interface is very similar to creating schemas for text tables. After the clipboard data are turned into a table compatible structure, the standard export/import interface is invoked where you can flexibly configure how the input data must be imported into a new or existing target table.

To start the process, copy the source data to clipboard, open your target database and choose Import | Import from Clipboard....

Note: This method is available in Exportizer and Exportizer Pro.

See also