problems converting Access db with blobs to MySQL

[walterk]

I have an Access database with about 100 records. Each record contains several small (embedded) JPEG images.

I need to export this db to MySQL. I am able to convert text only databases without any problems using the export to ODBC datasource feature. However, when trying to export the blob database I keep getting:

"ODBC--call failed error.

Information type out of range (#0)"

I have tried to dump the contents out of Access and then into MySQL but this also fails.

Is this the correct way to place images in a MySQL database or is it better to have a link to the images (assuming they are on my webspace)?

Thanks in advance.

[dataminded]

What is the datatype you're using in MySQL? Is it binary?

[walterk]

The export to ODBC function creates the database. Although since I can't get it to export the database with images I cannot tell if Access is trying to place the images into MySQL with the blob datatype.

Should it be binary?