[lug] Converting MS-Access to text/MySQL (fwd)

[Daniel J Urist]

On Thu, 10 Apr 2003, Jeff Schroeder wrote:

> 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.

In the process of trying to get my father-in-law off of access, I just ran
across a package called MDB tools that looks like it does exactly this. I
have no idea if it works (I haven't convinced him yet), but it certainly
looks promising:

http://mdbtools.sourceforge.net/

--
Dan Urist
durist at theworld.com