Epstein, Ed wrote:

> CSV is how we receive the data. I am required to parse it correctly and
> then insert into the appropriate tables. Not a big deal really. I can
> parse it just fine. Its just that inside of VB I can only acheive that
> ceiling of 300 tps to insert the data into IB. I was looking at External
> Files since there was a suggestion that creating the external file and then
> declaring it to IB would be the fastest way to insert the data. It
> certainly looks like it, but its a daunting task when I need to 500,000 rows
> regulary with about 15 fields per row. Last i looked I think i was right
> around 4k of data per row.
>
> The FBExport tool that was created uses a custom file structure (not CSV) to
> export and import its data from disk. I needed to know how to create that
> structure to use it properly.

I'm sorry, looks like I misunderstood you.

However, you can do it with FBExport. It has somewhat complex format,
I'll send it to you privately if you wish to pursue that path.

--
Milan Babuskov
http://fbexport.sourceforge.net