Re: Loading of Excel File into INFORMIX

Loh Kar Chiet <karchiet@singnet.com.sg> 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... You may save the Excel file as a text file and use dbload to load it. If you have MS Access and ODBC you can also connect to the Informix database and copy the data from Excel into a table in Informix. :Also, are there anyway to do string substitution in Informix 4GL? :say like CREATE TABLE $temp??? Something like: let p_temp = "whatever" let p_statement = "create table ", p_temp prepare s_statement from p_statement execute s_statement may perhaps fullfill your needs. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org