Subject | Re: [IBO] Datapump from text to gdb |
---|---|
Author | Helen Borrie |
Post date | 2001-12-07T11:28:37Z |
At 10:24 AM 07-12-01 +0200, you wrote:
For example, you can loop through the external data in a FOR SELECT loop in a stored procedure and process your 100K rows very quickly, even logging any records that fail validation, etc.
If you want users to browse the file, the external table can be queried into an IB dataset, just like any other table data.
For more info about external tables, see the IB manuals and ask on the ib-support list.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>I need a program, demo, or any component that imports data from an ASCIIIf you have any control over the format in which you receive the text file, then have it output in fixed-length format and use the external files feature of InterBase/Firebird. Then you can read the file as a FB/IB table and extract, cast, validate, query, just as you wish, from within the database.
>text file into gdb files,
For example, you can loop through the external data in a FOR SELECT loop in a stored procedure and process your 100K rows very quickly, even logging any records that fail validation, etc.
If you want users to browse the file, the external table can be queried into an IB dataset, just like any other table data.
For more info about external tables, see the IB manuals and ask on the ib-support list.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________