lec_sas wrote:

> Apparently I am not receiving any e-mails from the group at all. If
> anyone had any replies to my question, can you post it on the forums
> thread?
>
> Thank You
>

There is no way to do it using an "insert into select from" it's
considered as a single operation.

You could write a SP or a client app that scans the external table and
insert into the destination table. Remember that you will get better
performance using prepared statements, commit on batch's of 2000-4000
inserts.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br