I've found description below from IBPhoenix Development website but
I couldnt success it.

CREATE TABLE Foo [ EXTERNAL
[ DELIMITED [ DELIMITOR 'symbol' ] [ SEPARATOR 'symbol' ] ]
[ FILE ] 'pathname' ] ( ... )

is this syntax wrong?

ahmet,

--- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@o...> wrote:
> Ahmet Elgin wrote:
> > hi,
> > I want to use External Files as Tables. How can I format external
> > files? I want to use ';' character between fields as delimiter.
> > thanks for your interest.
> >
>
> There are no delimiters in external files (which are fixed format text
> files). If you intend to import delimited text you'll have to use some
> other means.
>
>
> --
> Aage J.