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

[rm at fabula.de]

On Mon, Apr 14, 2003 at 02:22:24PM -0600, Jeff Schroeder wrote:
> Ralf wrote:
> 
> > Just for the fun of it i downloaded/compiled the library and run my
> > old project against it. The data export went pretty well [1] and it
> > does everything i needed back then. So, if exporting or read-only
> > access is all you neeed i'd say go for it (the lib comes with an
> > unixODBC driver as well).
> 
> Thanks (to Daniel too) for the information.  This is *exactly* what I 
> needed!  I compiled MDBTools and it works fine.  I'm converting the 
> .MDB file into text, and can then post-process it for import into the 
> MySQL database.

Yes, i wish i had it two year ago. Back then i had to install perl on
a windows box and port all my code ...
BTW, for my tests i rewrote mdb-export to emit proper SQL insert statements
instead of CVS ;-)

 Ralf Mattes

> Jeff
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug