RE: [PHP] How to convert an MS Access to MySQL ?

Thanks, I checked that soft out. I suppose that is for those who have access and mySQL installed on the same machine. In my case I have no mySQL on my windows machine. What I want is to work out a way to create an sql file from the Access database just in the format MySQL dumps it for you when you use mysqldump to then use this file to create a database on the real Linux machine. Do you have an idea on how to do that? Cheers, Maxim Maletsky -----Original Message----- From: Wayne Michel [mailto:wayne@michel.com.au] Sent: Friday, November 24, 2000 1:41 PM To: Maxim Maletsky Subject: Re: [PHP] How to convert an MS Access to MySQL ? Have a look at DBTools, a windows program: http://dbtools.vila.bol.com.br/ Wayne ----- Original Message ----- From: "Maxim Maletsky" <maxim.maletsky@japaninc.net> To: <php-general@lists.php.net> Sent: Friday, November 24, 2000 3:15 PM Subject: [PHP] How to convert an MS Access to MySQL ? > Hello Guys, > > I have a rather big then just a simple problem. > > I need to convert MS Access database into MySQL. > > It all happened since the beginning of the days when people here at office > have started to think that the a real database is MS Access. Now I need to > integrate all that stuff with the web like emails to the mailing list, > from-the-web-submissions to the DB automatically etc... > > I can do that all just in a day or two, but what about the old data? it's in > Access and I already promised them to being able to concert it in mySQL > somehow. Exactly "somehow" but HOW? > > I hate windows already and I am not that confident in myself using the > access itself. I tried to look for some it's features but there's nothing > about exporting into SQL format. The only close thing to it I saw was ODBC > which I also don't know. > > How do I convert a 25 MB access database with 5 tables and lot's of other > strange unexplainable little things in it into a 'genuine' (better say > healthy) 5 tables mySQL database? > > PHS: in archives I found the code below to write a macro. Is that a proven > method? Can you please explain it to me more in details. > > Thanks in advance, > Maxim Maletsky. >