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.
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