Reading an excel and uploading data in mysql

Q&A
1

Hi All,

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

Thanks
Akhilesh

2

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.

3

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

4

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

5

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

6

this another question :wink:

7

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

Thanks in advance
Akhilesh