Link to home
Create AccountLog in
Avatar of Sybux
SybuxFlag for Switzerland

asked on

Convert Access 2010 to mySql with blob field

Hi all,

I need to convert an access DB (2010) to mysql. I've tested some tools like mysql worksheet, bullzip access to mysql. but everytime, I can't get the content of the field of type "Join FILE". Depending of the tools, I can get only the filename but not the content.

Do you know a tools that can do that ? shall I export all content then reimport to mysql ?

Thx for help.
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

I don't quite follow you ...

You've converted your database? And now you're trying to connect to that converted database?

Or are you having troubles converting your database?
Avatar of Sybux

ASKER

I'm having trouble converting "Attachment" field.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Sybux

ASKER

Finally I've written a little vba code to export all attachment to files then I've written back a php file to upload them in DB.

thx for help