Member Avatar for techkar

Hi experts,

here in my project ,there is a situation like, to read an Excel file and store in a database using java.
I have an excel file as 10 columns and this is a daily report by our sales team. So the requirement is to read that excel file and store in a database using java.please suggest me an idea.

Thanks

  • 3 Contributors
  • 2 Replies
  • 128 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by iamthwee
Member Avatar for masijade

Google the following one at a time and pick the solution you wish to use:

POI

JExcel

JDBC-ODBC Bridge

Member Avatar for iamthwee

Hi experts,

here in my project ,there is a situation like, to read an Excel file and store in a database using java.
I have an excel file as 10 columns and this is a daily report by our sales team. So the requirement is to read that excel file and store in a database using java.please suggest me an idea.

Thanks

As long as you don't have to WRITE anything to excel the easiest thing to do would be to convert your excel file to a comma separated file.

>file>save as > save type > choose .csv


Once you've done that you can use the comma in you file to tell the difference between each column.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.