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:
- Close the current database and open selected file or folder. If you choose this option, the current Exportizer database will be closed and the application will try to open one selected item.
- Copy selected files to open folder. This option is available, if the current Exportizer database is a physical folder with data files (e.g. dBase). If you choose this option, the application will try to copy selected items to that folder.
- Import tables from selected files or folders. This is the most powerful option. You can decide how to proceed:
- Quick importing. In this mode, the application tries to create a new table in the current database for each table found in the dragged files. After creating a table, it imports the data to it: all columns and all records.
- Let me choose import options. In this mode, you control every step and every import option. You can choose either to overwrite existing tables or append data to them, specify table and field mappings between source and target, and much more.
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.