[lug] Converting MS-Access to text/MySQL

[John Mueller]

Jeff, were you able to convert your Access data to MySQL?  If so, can you
tell me what application you used to make it happen?  I have been involved
with building an XML DB Exchange application and am currently doing some
market research on what competing applications are out there before we
launch the beta of it.  Thanks.

Regards,

J. Mueller
SmartBond
www.smartbond.net

e: jmueller at smartbond.net
p: 303-651-0200

Timeline Resume: http://www.vcglobal.com/jmm-resume/

> -----Original Message-----
> From: lug-admin at lug.boulder.co.us [mailto:lug-admin at lug.boulder.co.us]On
> Behalf Of Jeff Schroeder
> Sent: Thursday, April 10, 2003 11:10 AM
> To: lug at lug.boulder.co.us
> Subject: [lug] Converting MS-Access to text/MySQL
>
>
> 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
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.470 / Virus Database: 268 - Release Date: 4/8/2003
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003