Importing images

[tekslb]

Hello,

I have an Excel file with several columns and one of these have an image, is it possible to upload the information from the Excel file to the table?

If so, How?


Thanks in advance for the assistance.

 

[vacunita]

Its possible yes. But storing images in a DB is highly discouraged. Because it makes maintenance exponentially more complex, and delivery of the image requires significantly more code in the application accessing the database than a simple string path to the image.

Look at the blob field type in MYSQL for storing images.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[jpadie]

from recollection it is an almighty headache getting images out of office applications as they were/are stored in an OLE wrapper. it may be easier with the more recent versions of office (although the problem still persisted for access quite recently.

I ended up building an automation server that launched the image into an editor and took a screen shot of it. terribly kludge.