To access a remote server you can use a Linked server or OPENROWSET(). See BOP for details.
>To copy data from one table to another is....
>Sqlexec(lnHandle,"INSERT INTO detail SELECT * FROM detail2 WHERE reference=?m.ref order by reference")
>
>but how to copy from detail2 if the detail2 table is far from remote backend server ?
--sb--
