Re: Export from Access
If you are on Windows then you can directly import data using SQLyog's ODBC Import Tool. www.webyog.com Regards, Karam --- "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. > > Thanks > Steven > > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Export from Access
I've just seen the MySQL Migration Toolkit and looks very nice. Beautiful tool. On 5/17/05, 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. > > Thanks > Steven > > I've just seen the MySQL Migration Toolkit ans looks very nice. Marvelous tool. Excelent advice from Partha Dutta!!! -- Alvaro Cobo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Export from Access
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]
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]
Re: Export from Access
You can try a freeware utility you can find at: http://www.bullzip.com//products.php (I have tried it and works quite well) Additionally you could use DBDesigner (www.fabforce.com) and make a reverse engineer of you database and export it to a Sql file. Hope this help you. Best regards, Alvaro - Original Message - From: "S.D.Price" <[EMAIL PROTECTED]> To: "mysql" Sent: Tuesday, May 17, 2005 11:17 AM Subject: Export from Access 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. Thanks Steven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Export from Access
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. Thanks Steven
Re: export from Access so MYsql can read it
Use myodbc www.mysql.com/downloads/api-myodbc.html Best regards On Fri, 10 Oct 2003 12:34:48 -0400, Montagna, Dan wrote > Hi everyone, > > I'm using an Access database and trying to use a macro to export to > a text file for mysql. It's no problem to export to a text file, > but it's in a format that mysql won't recognize. I know it just > needs to be formatted on export a little but the macro options > aren't available for the extra formatting. Any help on how to > export to the proper .txt format would be great. > > Thanks > > Dan Laszlo Illyes Teaching-assistant Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
export from Access so MYsql can read it
Hi everyone, I'm using an Access database and trying to use a macro to export to a text file for mysql. It's no problem to export to a text file, but it's in a format that mysql won't recognize. I know it just needs to be formatted on export a little but the macro options aren't available for the extra formatting. Any help on how to export to the proper .txt format would be great. Thanks Dan
