Greetings all!!

I am splitting up a large table containing hundreds of thousands of
records onto multiple Firebird servers... What is the best way to
move a subset of records from a table on one server to a table in a
new database on another server?

Is it possible to name the source server\database\table in the from
clause of an INSERT INTO... SELECT * From... Statement??

I'm trying desperately to avoid reading and writing one record at a
time.

Thanks in advance!