--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:

>
> On 2/4/2011 5:43 AM, pavle.grebenar wrote:
> >
> >
> > --- In firebird-support@yahoogroups.com, "munster77054"<munster77054@> wrote:
> >>
> >> When I worked on a MAINFRAME database, I could use a "load" command to take a text file and load it into a table.
> >>
> >> For instance it would be something like this
> >>
> >> load<text file>, table, delimited by ","
> >>
> > what about external table ?
>
> As currently implemented, external tables use fixed sized columns,
> not comma separated values. Probably creating a CSV external table
> type would be harder than finding a tool that loads CSV files.
>
> Good luck,
>
> Ann
>

You can change any file to external file format
look at this page
http://www.firebirdsql.org/index.php?op=useful&id=netzka

i use this long time and this work perfectly :)
changing csv file 100MB in my situation take 2,5 seconds :)

Livius