[lug] Converting MS-Access to text/MySQL
jeff at neobox.net
Thu Apr 10 11:09:40 MDT 2003
I have a Microsoft Access database which I need to convert to MySQL. In
the past I've exported the Access data into a tab-delimited text file,
then parsed the file to run SQL statements and insert the data in a
However, it's impractical for me to manually export the data from Access
(for volume reasons). I'd love to find a program that can read a raw
.MDB file and convert it-- preferably to tab-delimited text, or else
import directly to MySQL. This needs to be scripted (via cron,
probably) so I can automatically parse and import the Access data.
I've searched Google, the newsgroups, and SourceForge but haven't found
anything. Surely someone else has this same problem-- I can't believe
the only answer is to do a manual export every time.
Any suggestions or pointers?
More information about the LUG