At 08:13 AM 1/11/2006, you wrote:

>Hello,
>
>Is there a maximum file size that can be used with Firebird (2.0) as
>an external table?
>If I use multiple files of 100 MB, there are no problems, but when I
>use a single file of 2.5 GB and 'insert into [Internal table] select
>from [External Table]' an IO error happens.
>
>I use Firebird 2.0 RC5 (on NTFS) with the fixed length file on fat32.

It's a FAT32 limitation - 2Gb maximum addressable. Put the file on a
NTFS partition that was created by NT 5. Note that a NTFS partition
that was created by NT 4.0 has a 4 Gb addressable limit.

./heLen