Sorry not command, It is a component, which allows quick copy from one table to another.
Coming to think of it, it might not work with cross database. You should look at it anyway.
Of course you can use use a query, to extract then a loop to insert. Slower but works.
Query1.SQL.ADD('SELECT * from TableA');
query1.open;
while not query1.eof do
begin
SQLStr:='Insert into TableB Values('+Query1.fields[0].asstring.......;
if query2.active then Query2.close;
Query2.sql.clear;
Query2.sql.add(SQLStr);
Query2.execsql;
end
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.