0

I have a list of data in excel list , how can i import them and insert into current created table. May i know the sql query for import excel data and insert into table ??Any help would be appreciated.

My excel list .CSV enter image description here

table describe enter image description here

new table with 0 record (13 columns same as excel list) enter image description here

user3835327
  • 1,194
  • 1
  • 14
  • 44
  • did u try this? http://stackoverflow.com/questions/1310166/how-to-import-an-excel-file-in-to-a-mysql-database or this http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html – Laky Aug 18 '15 at 03:39
  • It's not working on db2sql – user3835327 Aug 18 '15 at 03:44
  • normally i use 'Kettle' a data integration tool for complex data imports and extractions maybe you can try that. It's free to use http://community.pentaho.com/projects/data-integration/ – Laky Aug 18 '15 at 03:52

1 Answers1

0

DB2 has the IMPORT and LOAD for getting external data into tables. In your case I would recommend IMPORT.

This would be the general statement: import from yourfile of del insert into mytable

When you go to the documentation there are so-called "file type modifiers" that can be used to tell DB2 about the format of the data, the codepage, separators between the columns and more.

data_henrik
  • 16,724
  • 2
  • 28
  • 49