Help......Upload and store in MySQL DB

[maydhyam]

Hello,

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...

[maydhyam]

any guidance???

[Ezzaral]

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.

[maydhyam]

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...

[maydhyam]

I've been researching on the net, and I was reading about FileInputStream...in the java.io package...

[Ezzaral]

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