This section describes how to import or export records to/from an existing Access, Excel or Lotus database. You can also work with data in databases using scripts. Learn more....
Importing From 3rd Part Databases (Access, Excel, Lotus)
Using Brilliant Database you can import (export) data from databases of the following types:
Select the File > Import/Parse > Import From Access/Excel
menu item to open the import dialog:
For correct data import the following data should be specified: the database and the table to import records from (1-2), the folder and the record type to import records to (3) and the fields to import (4):
1. To select the database you want to import records from, click the Browse button (...) in the Import From pane.
2. In the drop down list of the Import From pane select the table to import records from.
3. In the Import To pane select the folder to import records to and the Record Type for the imported records.
4. In the Fields to Import pane set associations between the fields of the imported table and database fields by double clicking the field to import.
To start import, click the Import button.
On the Advanced tab you can set advanced import parameters:
To open the export dialog window, select the File > Export/Send > Export To Access/Excel menu item.
Records configuration and export into another database is performed similar to the import procedure.
Besides usual data export, using field correspondence, it is possible to change cells in another database with the help of a script during the export. Learn about exporting...
If you import (export) records frequently, the configuration of the data transfer (e.g., a path to the database, relation between the database fields, etc.) can be saved as a Preset. To work with presets, click the corresponding button in the bottom left part of the window:
Using Presets and Script Designer, you can completely automate the import/export process and perform it with one click.
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.