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
"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.
Joined: Aug 20, 2001
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 ]
Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
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
Joined: Apr 22, 2001
You have framework to read Excell files on jakarta it is POI.