C:\Program Files\Common Files\Borland Shared\BDE\LOCALSQL.HLP 참고하시구요..

Heterogeneous joins  라는 항목참고하시면 될겁니다.

SQL Explorer에서 다음과 같이 처리하니 데이터 일괄적으로 옮겨지더군요...
레코드 양이 많을때는 어떨런지 모르겠습니다...^^;  

CREATE TABLE TEST (AAA CHAR(255));

INSERT INTO ":DefaultDD:TEST.DB" (AAA)
select CAST(EMPNO AS CHAR(255)) from ":DBDEMOS:employee.DB"

즐프~

아래는 온라인 도움말 내용 그대로 옮깁니다.
--------------------------------------------------
Joins two tables from different databases.

SELECT column_list

FROM ":database_reference:table_reference", ":database_reference:table_reference" [,":database_reference:table_reference"...]

WHERE predicate [AND predicate...]

Description

Use a heterogeneous join to join two tables that reside in different databases. The joined tables may be of different types (like dBASE to Paradox or Paradox to InterBase), but you can only join tables whose database types are accessible through the BDE (local, ODBC, or SQL Links). A hetergeneous join may be any of the joins supported by local SQL. The difference is in the syntax for the table reference: the database containing each table is specified in the table reference, surrounded by colons and the whole reference enclosed in quotation marks. The database specified as part of the table reference may be a drive and directory reference (for local tables) or a BDE alias.

SELECT *

FROM ":DBDEMOS:Customer.db" C, ":BCDEMOS:Orders.db" O

WHERE (C.CustNo = O.CustNo)
==================================================

그냥 쿼리질의로 한방에 보내거나
단순히 변환하는 프로그램 하나 만드는게 낳을것 같은데요..쩝.
왜 고민하시는지...