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

Hey, That was Just TOO COOL. Love this mailing list, I've done 4 minutes after downloading the software. Your knowledge, guys, is HUGE! Thanks Michel (Wayne) Maxim Maletsky. -----Original Message----- From: Wayne Michel [mailto:wayne@michel.com.au] Sent: Friday, November 24, 2000 2:13 PM To: Maxim Maletsky Subject: Re: [PHP] How to convert an MS Access to MySQL ? DBTools will translate from Access on a windows box to MySQL on a linux box. Wayne ----- Original Message ----- From: "Maxim Maletsky" <maxim.maletsky@japaninc.net> To: "'Wayne Michel'" <wayne@michel.com.au> Cc: "'PHP General List. (E-mail)'" <php-general@lists.php.net> Sent: Friday, November 24, 2000 3:55 PM Subject: 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. > >