I need some help....I have to create part of an application that uploads an MS Excel file, and stores the data into a MySQL db...and I have no clue where to start...
Your question is too vague. By "upload" do you mean with a JSP page or from a desktop Java application? (This is the Java forum by the way. There is a separate JSP forum here:http://www.daniweb.com/forums/forum24.html)
Without more information no one can really help you.
Well, It's supposed to be a java desktop application that upload/loads the data from the MS Excel file (which is also on the desktop) into the specified table in a MySQL DB...
The file just needs to be inserted as a blob data type if you wish to store it directly in the database. You can find an example of using JDBC to store a Blob here: http://www.java2s.com/Code/Java/Database-SQL-JDBC/BlobJDBCdealswithBinaryData.htm