Manish,

M> CREATE TABLE TEMP1 EXTERNAL FILE
M> 'c:\EXTERNALTABLES\ext1'(ID INTEGER);

while nothing stops you from using non-char data types in external
tables, unless you know exactly what you're doing it is recommended
that you stick to fixed-length char types, and convert the numbers
later, when doing something like "insert into real_table ... select
... from ext_table". Such conversion is usually done transparently.

Also, make sure you are not writing unicode characters to the file
(this might be tricky, as I see you are using .NET).

...and don't forget to allow two chars for the line terminator, as
others have mentioned.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================