• Post Reply Bookmark Topic Watch Topic
  • New Topic

lading data from file into database

 
Muhammad Qureshi
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I have to load data from xls file to database, I have saved file as csv and had used stringtokenizer to parse it, now how can i load this data in to database.
 
Juanjo Bazan
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have to create/open a connection to your database using the suitable JDBC driver, and insert the data into the tables using SQL.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!