[lug] Converting MS-Access to text/MySQL

[Richard Fifarek]

	Not sure this would work, but there is an ODBC driver for MySQL 
that can be installed into MS Access.  Perhaps that would allow you to do 
some export/copy function.

On Thu, 10 Apr 2003, Jeff Schroeder wrote:

> 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 
> MySQL database.
> 
> 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?
> 
> TIA,
> 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
> 

-- 
Richard H. Fifarek
rfifarek at silug.org