Help Needed

Thread view:

kanthi - 12 May 2006 19:03 GMT

Hey guys,

I have a simple tab seperated file which has to be converted into excel
and also uploaded to a mysql database. how can i accomplish this in
java. Is there a sample code which illustrates this?
Please let me know.

Thanks in advance
Hima

Reply to this Message

Oliver Wong - 12 May 2006 19:33 GMT

> Hey guys,
>
> I have a simple tab seperated file which has to be converted into excel
> and also uploaded to a mysql database. how can i accomplish this in
> java. Is there a sample code which illustrates this?
> Please let me know.

When I google for "java excel", I get
http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html

When I google for "java mysql", I get
http://www.developer.com/java/data/article.php/3417381

- Oliver

Reply to this Message

tyshanchn - 13 May 2006 14:10 GMT

hi,

it is a easy job, I have once done such a job,

do as follows

get the CSV file from the excel and import the CSV file to mysql.

good luck

tyshan

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...