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
38
Posting Pro :)
Recommended Answers
Jump to PostYour 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.
Jump to PostThe 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 …
All 5 Replies
maydhyam
38
Posting Pro :)
any guidance???
Ezzaral
2,714
Posting Sage
Team Colleague
Featured Poster
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
38
Posting Pro :)
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...
Ezzaral
2,714
Posting Sage
Team Colleague
Featured Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.