Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: Excell to informix

    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..

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    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

  3. #3
    Join Date
    Nov 2002
    Posts
    25
    Convert your file first as csv. then, load it using the load command. I did it on my previous projects.

    thnks

  4. #4
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •