Home > IT Answers > Development > Loading image into MySQL database from Excel file
Wlm49hv
5 pts.
 Loading image into MySQL database from Excel file
Database programming, Microsoft Excel, MySQL
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

Software/Hardware used:
ASKED: March 30, 2009  11:57 AM
UPDATED: December 19, 2011  1:43 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I need an answer to this exact question as well. Sure, exporting an excel file as a CSV and importing it into MySQL is easy. As soon as the excel file contains images, this goes out the window. I assume you need a macro to create a custom file from excel, then you need to loop over this file and import into MySQL. I’d love some help with this, as I’m not very familiar with Excel or VBA.

Maraxus
 10 pts.