Ofcourse this is possible. It just require a little bit of work.
There are several ways to perform this operation. The first step, however, always is to get the data from MS Excel to something useable. (I have never tried exporting as HTML if thats possible, but MS html is NOT considered usable🙂.
The "main" technique to do this, is to export the database as a CSV file (Comma Separated Values). However, I have found that certain versions of Excel (especially the ones with norwegian language) tends only to support semicolon separated data -- As long as its text it should do.
Now, if you have the database in a human-readable format, the next problem is to get it in to mysql. There are basically two approaches (that I know of) to do this:
1) MySQLs 'load' function. This one is quite complicated and can do wonders. Read the MySQL manual for more info on this.
2) Write a script/program (perl, c, python, PHP or whatever you like) to read the file, line by line,. For each line, split it according to whatever delimiter excel saved with, and generate one sql query for each line (insert a row in the db).
I'd use one of the above, probably the second if I needed some logics into it (e.g. inserting 'firstname' and 'lastname' from excel combined to 'name' in mysql, or anything else that might help you use your existing mysql database).
