|
Importing Data into Advantage Tables Advantage Data Architect |
|
|
|
Importing Data into Advantage Tables Advantage Data Architect |
|
|
Use the ARC Import Utility to move data (both schema and content) into Advantage Database Table (ADT) format. To start the ARC Import Utility, select Tools | Import Data from the main menu.
The following types of tables can be directly imported using ARC:
| • | Paradox\dBase Tables |
| • | Advantage FoxPro Tables |
| • | Advantage CA-Clipper Tables |
| • | Text Files |
Data may also be imported from the following data sources:
| • | Any BDE alias |
| • | Any ADO data source |
| • | Any Btrieve data source |
To import data:
| .2. | Select the type of data to import. |
| .3. | Input the location of the data by directory or data source. |
| .4. | Input the location for the new Advantage data. |
| .5. | Import the data. |
Considerations when Importing Data Into the ADT File Format
To use a Borland Database Engine (BDE) alias, the BDE must be installed on the machine. If the BDE is not installed on the machine, a version can be downloaded from the Advantage Developer Zone Web site at: http:\\DevZone.AdvantageDatabase.com.
To use an ADO data source, the following items must be installed on the machine: Microsoft ADO 2.1 or greater, and an OLEDB or an ODBC driver for access to the data to be imported. The latest Microsoft ADO driver can be downloaded from the Microsoft Web site (search for MDAC in the downloads area).
To use a Btrieve data source, the client machine must have Pervasive SQL client installed and a server available for it to access the data. At the present time, the import utility does not support data from Btrieve blob and variable length LVar fields.