At 01:48 PM 6/02/2003 +0100, you wrote:

>Hi all,
>
>I noticed that the "create table" statement with "external file" option
>results in Interbase creating a new empty external file
>However, I want to associate the table with an existing filled external file
>How should this be done ?

You need a full file specification (not relative paths or anything else)
and, of course, the file must be located on a drive that is local to the
server.

create table aTable external file 'd:\files\MyFile.txt'
(<column specifications>
...
);

heLen