| Subject | Data Pump: More efficient way? |
|---|---|
| Author | homerjones1941 |
| Post date | 2004-09-05T07:32:34Z |
In moving data from MS Access to Firebird I am using ADO to read the
Access tables, and an IBQuery to write the data to Firebird. Sort of
like this:
While Not ADOQuery1.eof do begin
IBQuery.Append;
< Code setting IBQuery fields := ADOQuery fields >
< Some fields must be translated in the process >
IBQuery.Post;
ADOQuery1.Next;
end; // While...
Field names are not a one-to-one match, and data types are also not
a perfect match either (example boolean to Char(1)).
Since I am new to Firebird, and IBObjects, is there a more efficient
way?
Access tables, and an IBQuery to write the data to Firebird. Sort of
like this:
While Not ADOQuery1.eof do begin
IBQuery.Append;
< Code setting IBQuery fields := ADOQuery fields >
< Some fields must be translated in the process >
IBQuery.Post;
ADOQuery1.Next;
end; // While...
Field names are not a one-to-one match, and data types are also not
a perfect match either (example boolean to Char(1)).
Since I am new to Firebird, and IBObjects, is there a more efficient
way?