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.

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.

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 the 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.