Reading an excel and uploading data in mysql

Submitted by akhilesh.pathak on Thu, 04/10/2014 - 11:16
1
0
-1

Hi All,

Is there any connector available for bontia 6.2 for reading and excel sheet ?

Thanks Akhilesh

Comments

Submitted by ttoine on Thu, 04/10/2014 - 14:38

.csv is enough? or your really need a Excel file? and which version of Excel?

Permalink
Submitted by akhilesh.pathak on Thu, 04/10/2014 - 14:46

Thanks for your response. Actually I want to read an excel file of version 2007/2010 (.xls or .xlsx). After reading i want to insert that data into mysql. How can I achieve this ? Can you please help ..

Thanks Akhilesh

Permalink
Submitted by akhilesh.pathak on Thu, 04/10/2014 - 15:37

Thanks for your quick response. (Bonita 6.2) In MySql connector, how we can insert multiple rows ? Because the insert statement allows one row at a time ?

Thanks Akhilesh

Permalink
Submitted by ttoine on Thu, 04/10/2014 - 16:16

this another question ;-)

Permalink
Submitted by akhilesh.pathak on Thu, 04/10/2014 - 16:19

Ya I know , but can you please answer it. I need t urgently.

Thanks in advance Akhilesh

Permalink
1 answer

Submitted by ttoine on Thu, 04/10/2014 - 14:52
1
0
-1

I would try to find a java library would read the data from excel files and transform it in .csv or something like that. Use it in a custom connector. And then send the data with the mysql connector.

  • 274 reads
Notifications