| Subject | importing datas |
|---|---|
| Author | Paul MAJGIER |
| Post date | 2002-10-02T11:37:58Z |
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,,,,
'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.