Hi,
you don't need write any SP and open any cursor/loop to bulk insert
from external table.

Try this:

insert into mytable(col1,col2,...)
select col1,col2,... from myexternaltable;

single sql command and engine level internal loop...
may something be more faster?

you can also do cast, substring etc. operations on source columns if
you need.


Regards.

Ali

Firebird Foundation Member #208