I have an application that uses OLE/DB to pump data from an AS/400
database to a Firebird 1.5 Database. Records are read and
reformatted and posted to the Firbird database. It works reliably
but too slow. It took 8 hours to post 2 Million records into a
table. I need to cut this down to say 1 or two hours.

The application reads each record from the AS/400 and constructs an
SQL statement to insert the record into the Firebird database table
i.e.

INSERT INTO FBTable (MyField1, Myfield2 ...) VALUES (MyValue1,
MyValue2...)

Is there a faster way? Would parameter substitution help?
Regards
Peter Gore