Re: Loading of Excel File into INFORMIX

Mauro G. Pisano wrote: > > At 10:01 PM 10/09/97 +0800, you wrote: > }Hi...I'm new here... > } > }I'm currently facing a problem of uploading an Excel File from Windows > }into INFORMIX in unix.... > }however, I haven't been able to find a way to do so... > }hope you guys can give me some pointers... > }thanks... > } > }Also, are there anyway to do string substitution in Informix 4GL? > }say like CREATE TABLE $temp??? > } > }Thanks... > } > }Casey > } > } > > A possible solution may be: > > - Unload the Exel File with a delimiter like "|" > - Create a table on Informix with the Exel File's columns like fields > - execute the following SQL: Load From "Exel File" insert into 'table' > > NOTE: verify that the Exel File contains after each field the delimiter > "|", becuase Informix searches for End Field delimiter. > sed 's/$/|/' <excel_file >dbload_file will add the _required_ but not-included-by-Excel trailing delimiter. Wake.