Migrating images from Access to mySql database

[latex88]

Hi,

I need to migrate a table of data that one of the field contains images which is OLE Object datatype. Via ODBC, I tried to use update query and append query. All the fields would migrate over, but neither type of query would transfer the image from Access to mySql correctly. Has anyone had success in this attempt? If so, what is the best practice to do so?

 

[GinaWhipp]

Well, while I believe you can use the BLOB (or other binary) data type to store your images. (FYI, the way 99.9% of developers use is to store the location (URL) of the image.)

Try UPSIZING the table (or importing it in) rather then using a query to UPDATE or APPEND an existing table.

 

[latex88]

I am trying to import the data in. However, I am only familiar with MS Access, not mySql, hence my problem. Without having images in one of the fields, using the append query works without issues, but when the image is involved, that particular field turns to garbage in mySql.

 

[Lightwave]

This template may prove useful - in your case it would be ensuring that you know the filenames related to each image then moving all images across to a single directory and then programmatically arranging it that whenever a record is clicked it looks to your database for the specific filename and then gets the standard unc path for where the files are held and then implement with the appropriate technology. Like Gina says effectively no one around here uses Access to store images in databases so you'll be a long time wating for an answer.

http://www.access-programmers.co.uk/forums/showthread.php?t=120834&highlight=storing+images

 

[GinaWhipp]

Latex,

It will turn to garbage *unless* you use a BLOB or binary data type and even then you will *see* the image. PLEASE see the sample provided by LightWave and stop trying to store the actual image in the table.