Sybux
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.
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.
ASKER
I'm having trouble converting "Attachment" field.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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
thx for help
You've converted your database? And now you're trying to connect to that converted database?
Or are you having troubles converting your database?