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

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