dbTalk Databases Forums  

URGENT : procedure to import data from excel sheet

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss URGENT : procedure to import data from excel sheet in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ratan
 
Posts: n/a

Default URGENT : procedure to import data from excel sheet - 10-08-2007 , 11:46 PM






hi everybody,

i want d code for d procedure to import data from excel sheet to db2
table. can anybody plz help me? its quite urgent.

my mail id is ratan.nitrkl (AT) gmail (DOT) com, yahoo chat id:
ratan_nitrkl (AT) yahoo (DOT) com


Reply With Quote
  #2  
Old   
Lennart
 
Posts: n/a

Default Re: URGENT : procedure to import data from excel sheet - 10-09-2007 , 10:15 AM






On Oct 9, 6:46 am, Ratan <ratan.nit... (AT) gmail (DOT) com> wrote:
Quote:
hi everybody,

i want d code for d procedure to import data from excel sheet to db2
table. can anybody plz help me? its quite urgent.

my mail id is ratan.nit... (AT) gmail (DOT) com, yahoo chat id:
ratan_nit... (AT) yahoo (DOT) com
Simplest aproach is to save the file in csv format, and then use
import. If not possible, have a look at http://poi.apache.org/. I
havent tried it in a java procedure, but the api is rather
straightforward to use otherwise


/Lennart





Reply With Quote
  #3  
Old   
pamela fluente
 
Posts: n/a

Default Re: URGENT : procedure to import data from excel sheet - 10-09-2007 , 10:30 AM



On 9 Ott, 06:46, Ratan <ratan.nit... (AT) gmail (DOT) com> wrote:
Quote:
hi everybody,

i want d code for d procedure to import data from excel sheet to db2
table. can anybody plz help me? its quite urgent.

my mail id is ratan.nit... (AT) gmail (DOT) com, yahoo chat id:
ratan_nit... (AT) yahoo (DOT) com
You can do it in a few seconds with this:
http://www.datatime.eu/download.aspx

Connect to Excel > Database explorer > Quick Export ("table setup" to
control mapping, Use "dump to file" to see a preview)
Do write to me in case of question or problems.


-P

-------------------------------------------------------------------------------------------
Providing DB2 users with the world's best Reporting Solution



Reply With Quote
  #4  
Old   
Ratan
 
Posts: n/a

Default Re: URGENT : procedure to import data from excel sheet - 10-10-2007 , 07:48 AM



On Oct 9, 8:30 pm, pamela fluente <pamelaflue... (AT) libero (DOT) it> wrote:
Quote:
On 9 Ott, 06:46, Ratan <ratan.nit... (AT) gmail (DOT) com> wrote:

hi everybody,

i want d code for d procedure to import data from excel sheet to db2
table. can anybody plz help me? its quite urgent.

my mail id is ratan.nit... (AT) gmail (DOT) com, yahoo chat id:
ratan_nit... (AT) yahoo (DOT) com

You can do it in a few seconds with this:http://www.datatime.eu/download.aspx

Connect to Excel > Database explorer > Quick Export ("table setup" to
control mapping, Use "dump to file" to see a preview)
Do write to me in case of question or problems.

-P

---------------------------------------------------------------------------*----------------
Providing DB2 users with the world's best Reporting Solution
thnx Lennart n pamela fluente for ur response.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.