Importing Paradox data into an InterBase database 
Author Message
 Importing Paradox data into an InterBase database

I'm doing an app, where I need to be able to import data from Paradox
tables into an InterBAse database, on a regular basis. How do I do
this? As it is now, I'm doing an INSERT-query for every record in the
paradox table, and it is S-L-O-W!

Is it possible to do a SELECT-query that uses the Paradox table as
selection criteria into data in the InterBase database? (I have to
check for the existence of the imported records, before importing, to
be able to let the user choose if the IB database should be updated
for that record.) And is it possible to do an INSERT-query from the
Paradox table, into the InterBase table?

CUL8R dude!                       \|/

Jens  +-----------------------oOO-(_)-OOo-----------------------+

      +---------------------------------------------------------+



Wed, 18 Jun 1902 08:00:00 GMT  
 Importing Paradox data into an InterBase database
A couple of suggestions:

1.  Look up heterogenous joins in Delphi Help.

2.  If your tables are the same (structurally), try using a BatchMove
component.

********************************
Michael Glatz




Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Q: Import Dbase-Data into Interbase SQL ?

2. Importing existing data to Interbase from MS Access or Excel

3. Importing existing data to Interbase from MS Access or Excel

4. importing data to paradox tables.

5. Importing data into Paradox 7 table

6. Import ASCII data to PARADOX table

7. Importing data into BDE via Database Desktop

8. Import and Export of database data

9. Paradox 5.0 data packing + Large Database Problem

10. BDE data loss problem ( local paradox database)

11. Paradox database migration (InterBase)

12. Delphi application switching between InterBase and Paradox databases

 

 
Powered by phpBB® Forum Software