Re: Loading of Excel File into INFORMIX

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. I hope this help you. @@@@ @@@@@@@ Mauro G. Pisano @@@ @@@ @@@ @ Analista Programador. @@@ @ @ @@@@@@@ Direcc. Gral. de Cultura y Educaci'n. @@@ @ @@@ - Liquidacion de Sueldos Transferidos/EGB - @@@ @@@ Email: mpisano@ed.gba.gov.ar