Hi all,

I work with FireBird and interserver 2.01

Anyone can tell me, how can I import datas in a table from text files with this format :

(Sample)

'stds','Standard','Estándar','Standard',,0,,,,
'medi','Standard ++','Consuelo','Confort',,0,,,,
'supe','Superior','Superior','Supérieure',,0,,,,
'luxe','Deluxe','De lujo','Luxe',,0,,,,
'prtg','Prestige','Prestigio','Prestige',,0,,,,
'suij','Junior Suite','Junior Suite','Suite Junior',,0,,,,
'suit','Suite','Suite','Suite',,0,,,,
'suip','Prestige Suite','Prestigio Suite','Suite Prestige',,0,,,,
'simp','Single','Simple','Simple',,0,,,,
'doub','Double','Doble','Double',,0,,,,
'twin','Twin','Twin','Twin',,0,,,,
'trip','Triple','Triple','Triple',,0,,,,

I know with other isql clients it possible to use :
"INPUT" and
"LOAD"

But with the isql of Firebird
"LOAD" doesn't exist and
"INPUT" can import .sql files but not import text files with only datas


OR


Have you acknowledgement of a program who copy structure and datas of a "sysbase" file to a "firebird" file ?


many thanks,

Paul.



[Non-text portions of this message have been removed]