Copy data from a table to another table

[isr123]

Hello all,

How to copy data from a table on a server to a table on another server,
using ADO.

How to use a Stored Procedure to copy the data.

Many thanks
I. Nemlich

[grenzgaenger]

hello isr123,

I think, this is not possible with stored procedures. read the tables which you want with a query or a tTable component and transfer the date to the other TADOConnection and insert them into the database ... has the table the same structure so you can use such kind of ..

t1.first
while not t1.eof do
begin
 t2.insert;
 for i := 0 to t1.fieldcount -1 do
   t2.fields := t1.fields;
 t2.post;
 t1.next;
end;


<HTH> GG

[isr123]

This is actually the way I am performing copy data between 2 servers but it is very slowwwww!! and I am looking for a quicker solution.

Many thanks

I. Namelich