Import > From BDE Database > SQL from other BDE Database

Retrieving data from other BDE compliant databases

If not both the source an destination databases are of the Paradox type, import has to be done via SQL from some available BDE database.
SQL import is done by:

SELECT * FROM {source database}.{source table name}

as e.g. from a file location:

SELECT * FROM "D:\Data\DBDemos\animals.dbf"

or from a BDE database alias as:

SELECT * FROM ":DBDEMOS:animals.dbf"

and subsequently saving the SQL-retrieved data via the
[Export] menu by [Save Current Query Result as Current Table Format]
saving the data as a Paradox/dBASE/FoxPro table depending on the currently active database selection.

Be aware, that some data types as well as column names may be incompatible if retrieved from some database different from the current one.