Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57

    Red face Unanswered: How To Import Data From Excel File

    Dear Friend,

    I have one table in DB2 and some data in excel file.
    Any one can tell me how to import all data from excel sheet to my table which is in DB2.
    i am using windows 2003 server edition and office 2000 and DB2 UDB 8.2
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    excel

    save the excel sheet in csv format and try the db2 import command with file format del
    db2 import from xxx.csv of del insert into tablename

    if needed specify coldel
    db2 import from xxx.csv of del modified by coldel" insert into tablename
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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