I recently developed an application using Servlets and JSP. The data for the application is supposed to be updated into Mysql through a batch file or excel file.how do i go about dumping data from excel to mysql using java or are there any tools available for it??
If you want it put into MySQL server (instead of the bridge, which can be slow) you have to write your own JDBC conversion tool to perform the insert. Because Excel is a flat file and databases are generally highly structured, there's no magic tool to dump the file into the database. As Paul mentioned, the Apache POI API is a great tool to use in writing such a conversion tool. [ July 14, 2008: Message edited by: Scott Selikoff ]