Board index » delphi » Copy data from table to another one?

Zero

Delphi Developer
Sat, 02 Oct 2004 00:05:45 GMT

Copy data from table to another one?

I use Delphi 5 and Access 2000 as my database.  The ADO components are used.
I want to copy data from table A in xxx.mdb to table B in yyy.mdb which have
the same data structure but with different connection.  I want to use a
ADOCommand to do this task.  But, I don't know how to write the SQL
statement due to the tables with different connection.  Please help me.
 
Brian Bushay Team

Delphi Developer
Sat, 02 Oct 2004 13:04:33 GMT

Re:Copy data from table to another one?


Quote
>I use Delphi 5 and Access 2000 as my database.  The ADO components are used.
>I want to copy data from table A in xxx.mdb to table B in yyy.mdb which have
>the same data structure but with different connection.  I want to use a
>ADOCommand to do this task.  But, I don't know how to write the SQL
>statement due to the tables with different connection.  

You just use one connection and specify the full path to the second .mdb like
this

INSERT  INTO TableA
 (Select SomeFields From TableB IN 'C:\MyFolder\MyDatabase.MDB' )
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. copying data from one table to another

2. Copy data from one table to another

3. Copy Table Data from one DB to Another

4. How to: copy a record from one table to another one

5. Copying one record from one table to another

6. New Table pointer and/or copying a tables data

7. Prob moving data from one table to diff table with array

8. pump data from one database table to another database table

9. copying data from one record to the next when inserting a new record

10. How do I Copy Data from one Database to another Database using ADO