Import Data from MS Access
Posted by shajan (shajan), 24 September 2002Hi
I am allready having an MS access database. how to convert that data into MySQL?
Access is in Windows NT and MySQL is in Redhat Linux.
Thanks in advance.
Posted by admin (Graham Ellis), 24 September 2002Hmmm .... I'm a lot weaker on Access than are others who are around here so will some of you who I know lurk please follow up on my answer. Thanks!
As I understand it, Access is different to other databases in that it's a file format that's used directly by applications or .dlls within applications, rather than by a daemon. It would probably be unkind to call it "a toy", but I imagine that your reason for moving is because you're running out of steam?
There are probably a number of routes you could take; I've done a search and come up with myODBC as one possibility ...
The full text (including the 10 steps to follow) is at:
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho