By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,286 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,286 IT Pros & Developers. It's quick & easy.

URGENT : procedure to import data from excel sheet

P: n/a
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 ra**********@gmail.com, yahoo chat id:
ra**********@yahoo.com

Oct 9 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Oct 9, 6:46 am, Ratan <ratan.nit...@gmail.comwrote:
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...@gmail.com, yahoo chat id:
ratan_nit...@yahoo.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

Oct 9 '07 #2

P: n/a
On 9 Ott, 06:46, Ratan <ratan.nit...@gmail.comwrote:
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...@gmail.com, yahoo chat id:
ratan_nit...@yahoo.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

Oct 9 '07 #3

P: n/a
On Oct 9, 8:30 pm, pamela fluente <pamelaflue...@libero.itwrote:
On 9 Ott, 06:46, Ratan <ratan.nit...@gmail.comwrote:
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...@gmail.com, yahoo chat id:
ratan_nit...@yahoo.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.

Oct 10 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.