RE: How to port MS Access to MySQL ??

2002-11-12 Thread Terry
MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql - Before posting, please check: http://www.mysql.com/manual.php (the

RE: How to port MS Access to MySQL ??

2002-11-12 Thread Alan McDonald
MySQLFront will create the tables and pump the data with one button press Alan -Original Message- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 November 2002 22:02 To: [EMAIL PROTECTED] Subject: RE: How to port MS Access to MySQL ?? MyODBC works fine, but what

RE: How to port MS Access to MySQL ??

2002-11-12 Thread Ed Reed
:02 To: [EMAIL PROTECTED] Subject: RE: How to port MS Access to MySQL ?? MyODBC works fine, but what to do if you have hundreds of tables?=20 its painful job, maybe theres some easier way to do that ? regards, terry sql

Re: How to port MS Access to MySQL ??

2002-11-08 Thread Petre Agenbag
myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into

Re: How to port MS Access to MySQL ??

2002-11-08 Thread Crercio O. Silva
Hi, Use DBTools DBManager. It import/converts from MSAccess, DBF (Dbase, CLipper, FoxPro), Paradox, ODBC e MSExcel into MySQL with just a few clicks. Of course it only works in Windows. http://www.dbtools.com.br []s Crercio O. Silva - Original Message - From: tmb [EMAIL PROTECTED] To:

Re: How to port MS Access to MySQL ??

2002-11-08 Thread stibs-pi
Yep, ODBC works great. Make a connection from Access to MySQL and mirror the access db into MySQL. STIBS myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables

RE: How to port MS Access to MySQL ??

2002-11-08 Thread Alan McDonald
MySQLfront does it all -Original Message- From: tmb [mailto:topmailbox;yahoo.com] Sent: Friday, 8 November 2002 23:18 To: [EMAIL PROTECTED] Subject: How to port MS Access to MySQL ?? Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create

RE: How to port MS Access to MySQL ??

2002-11-08 Thread tmb
Alan, 1 - what is MySQLfront? 2 - where can I get it? 3 - does it run under Linux? 4 - is it open source /or free? 5 - or does it come with MySQL ?? thanks - tmb --- Alan McDonald [EMAIL PROTECTED] wrote: MySQLfront does it all -Original Message- From: tmb

Re: How to port MS Access to MySQL ??

2002-11-08 Thread tmb
Petre, Where do I get MyOdbc ?? Does it run on linux? thanks - tmb --- Petre Agenbag [EMAIL PROTECTED] wrote: myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the

RE: How to port MS Access to MySQL ??

2002-11-08 Thread mos
Try http://mysqlfront.sstienemann.de/ and wait a few seconds for the download to start. MySQLFront has been discontinued by the author a couple months back. See if you can get a copy before it gets pulled off the net. It is very very good. :) It is free. Mike. At 04:59 PM 11/8/2002, you