File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to insert data from file excel into DB?

 
blue sky
Greenhorn
Posts: 12
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
Could you please tell me how insert data from Excel file to database.
Example: my excel file include members information (username,pwd,email,fullname). My DB have table member. And I want insert list members from excel to DB
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"good luck",
It appears that you have changed your name from a valid display name to an invalid display name. Please change it back, accounts with invalid display names get deleted.
This is not a servlet question, I'm moving it to the JDBC forum.
Dave.
 
Joel McNary
Bartender
Posts: 1824
Eclipse IDE Java Ruby
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, you could create an ODBC driver to your Excel file and read and write data that way (using the JDBC-ODBC Bridge). Also, depending on the database, there may already be conversion utilities available (Access and SQL Server have such utils (them being M$), but I think other DBs do as well...)
[ November 19, 2003: Message edited by: Joel McNary ]
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If possible, from excel save the file as a tab delimited text file. Read the file in, parse the data columns ( use reg. expressions if possible ) then write each line of data to your database. I do have delimited file reader class (for JDK 1.4) that can make this easier if you decide to go that route.
Jamie
 
Vladimir Ergovic
Ranch Hand
Posts: 63
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have framework to read Excell files on jakarta it is POI.
 
SJ Adnams
Ranch Hand
Posts: 925
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
export as csv, then import using sql-loader
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic