SEO

#1 (**permalink**) 02-27-2008, 01:07 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@gmail.com, yahoo chat id:
ratan_nitrkl@yahoo.com

#2 (**permalink**) 02-27-2008, 01:07 PM

On Oct 9, 6:46 am, Ratan <ratan.nit...@gmail.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...@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

#3 (**permalink**) 02-27-2008, 01:07 PM

On 9 Ott, 06:46, Ratan <ratan.nit...@gmail.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...@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

#4 (**permalink**) 02-27-2008, 01:07 PM

On Oct 9, 8:30 pm, pamela fluente <pamelaflue...@libero.it> wrote:
> On 9 Ott, 06:46, Ratan <ratan.nit...@gmail.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...@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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

URGENT : procedure to import data from excel sheet