I think that the best approach would be to use the MySQL Migration Toolkit. Why spend a lot of time writing a tool when something already exists, and it works with Microsoft Access?
http://www.mysql.com/products/migration-toolkit/ -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification > -----Original Message----- > From: EP [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 18, 2005 2:02 AM > To: Josh Trutwin; mysql@lists.mysql.com > Subject: Re: Export from Access > > I recently exported a large Access database to MySQL using MyODBC. > > It took me a while to figure out that MyODBC was the thing to try, but > once I did tried it, it only took me a few minutes to do the export. I > highly recommend that approach (MyODBC). > > -Eric > > > > > ------------Original Message------------ > > From: Josh Trutwin <[EMAIL PROTECTED]> > > To: mysql@lists.mysql.com > > Date: Tue, May-17-2005 10:19 AM > > Subject: Re: Export from Access > > > > On Tue, 17 May 2005 17:17:31 +0100 > > "S.D.Price" <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > can anyone explain how I would export a database created in Access > > > to MySQL using PHPMyAdmin - I can't seem to import the data as csv > > > or txt. > > > > Acess should allow exporting to CSV. Otherwise you can skip > > phpMyAdmin and just use ODBC - check out MyODBC on mysql.com. > > > > Josh > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]