RE: Loading of Excel File into INFORMIX

Actually, you can create a Visual Basic module within the spreadsheet. = =20 Your VB code could then use an ODBC data source to insert the=20 spreadsheet data into the target Informix database table(s). Refer to = your Excel User's Guide and Excels Visual Basic User's Guide for detail= s. Another source is on Microsoft's web page. Check out www.microsoft.com/kb/articles/q145/8/26.htm for an example. Good Luck. Mark Baumgartner DBA Cardinal Health ---------- From: "Mauro G. Pisano" <mpisano@ed.gba.gov.ar> Sent: Wednesday, September 10, 1997 3:07 PM To: dgeaix1.ed.gba.gov.ar!karchiet@singnet.com.sg.gba.gov.ar Cc: informix-list@rmy.emory.edu Subject: Re: Loading of Excel File into INFORMIX <<File: RFC822.TXT>> 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 field= s - execute the following SQL: Load From "Exel File" insert into 'tabl= e' NOTE: verify that the Exel File contains after each field the delimiter= "|", becuase Informix searches for End Field delimiter. I hope this help you.=20 @@@@ @@@@@@@ Mauro G. Pisano @@@ @@@ @@@ @ Analista Programador. @@@ @ @ @@@@@@@ Direcc. Gral. de Cultura y Educaci=F3n. @@@ @ @@@ - Liquidacion de Sueldos Transferidos/EGB - @@@ @@@ Email: mpisano@ed.gba.gov.= ar =