hello there,
it`s posible for me to take all the data in the excell form to the current table in the informix. The column inside the excell is exactlly the same as the field inside the table in the informix. is there any tools or i need to do a script. if i need to do the script can i use in vb language?pleasse help me..

Hi,

There are tools available in informix to load data from a flat file to informix table. You can use dbload or load utilities.

Save the excel file as CSV file, and use:

load from data.csv delimiter ","
insert into target_table

Bye

Nitin

Convert your file first as csv. then, load it using the load command. I did it on my previous projects.

thnks

if you do the "," delimited file then make sure there are no commas in you data or Informix will take that as a separate field.

If that's the case than the way I got around that is save the file as .txt tab delimited and then just substitute tab for a "|" in vi

Good luck