• Post Reply Bookmark Topic Watch Topic
  • New Topic

Import Excel sheet data to database  RSS feed

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
dear experts!

i need to import Excel sheet with thousand of records to sybase database using java coding.
It should not create any performance related issues / data loss.
can any one guide me to achieve this. thanks in advance!
 
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apache POI is a good library to read Excel files. You'd use the JDBC API to access the DB.
 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf Dittmer wrote:Apache POI is a good library to read Excel files. You'd use the JDBC API to access the DB.


This.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!