Subject Re: [firebird-support] Bulk Upload facility in Firebird
Author Helen Borrie
At 10:03 AM 10/10/2005 +0530, you wrote:
>Is there any kind of bulk upload (BCP) utility available in firebird


>We need to insert thousands of records in bulk into a table.

That's a different question. If you can convert the data to a fixed length
text format, you can read this data file directly as an external table with
cols defined to be compatible types. It's very quick, as you read from
the external table and insert to the real table in one go using the syntax

insert into realtable (<column_list>)
select <type-matched_column_list> from externaltable

However, there are datapump tools around that can convert data directly
from a number of common data or database formats, including Access and
CSV. Refer to the appropriate page in the Contributed Downloads area at