1) create table 2) save as tab-delimited file 3) import data
Joined: Jun 13, 2008
hi, thanks for yr replay i have jsp page that contain browser button when i pressed that button particular excel file is selected and i have import button when i pressed that all values have to store particular table in mysql database.how to do please help me
Your problem is far from clear. Are you selecting this file from the client? If so, you will need to upload it to your server. That isn't a JDBC problem, but file uploading has been discussed many times in the Servlets and JSP forum.
Next, if these are really Excel files and you can't get tab-delimited or comma-delimited files, you'll need some code that can read them successfully. Apache POI or JExcel are two possibilities. Likewise this isn't anything to do with JDBC.
Finally, once you get the data out of the Excel format you will have to write it into your database. This requires understanding the data that is being transferred, including how it is stored in the Excel file and what tables and columns it must be put into in the database.