Do you want the whole process to be automated?

If that is the case, you could use the Excel API and convert the Excel file to some program understandable text format and write a program to extract and write the info to the database.

------------------------

Programming ( Assignment / Project ) Help

has anyone already written a program that does this that i could use?

Yes, you can script a solution. The question then is, what programming languages are you comfortable with? If you are not a programmer, then you need to find one.

You can use ODBC drivers to connect directly to an Excel file. You can then iterate the rows just like a normal SQL table. So your code would iterate the rows in Excel, and update the MySQL db as necessary.

Once you know what language you prefer to use, you should post in the appropriate programming forum--your question is really a programming question, not a database question.

write a program to update a data using jsp

It has to show in a table using html code,i tried but am getting error.Please reply