Hi, Try this MS Access macro (VB): http://www.cynergi.net/exportsql/exportsql2.txt.
I have used it but needed to: - change it to filter out the tables I needed - alter the way the "create" statements were generated Regards, Petter Ulltveit-Moe -----Mensaje original----- De: John Ragan [mailto:jragan@;arkansas.net] Enviado el: domingo, 10 de noviembre de 2002 2:58 Para: [EMAIL PROTECTED]; stefano.scattini Asunto: Re: I: How to port MS Access to MySQL ?? although i make a living from their products and corereader runs under windows, i really really hate to give macrosoft a plug. but i keep seeing this kind of question here, so here's what i do, if you have the tools. 1. i fire up enterprise manager for ms sql server, because it has a pretty slick dts mechanism. (man, i hate writing that.) 2. then i suck the access database into ms sql. 3. then i alter whatever needs to be cleaned up inside the server for whatever server it's going to. 4. then, still inside enterprise manager, i send it to mysql, or oracle, or whatever. super simple and easy. argh! gotta wash my mouth out with soap. > I use navicat http://www.mysqlstudio.com/. > > ing. stefano scattini > > > -----Messaggio originale----- > Da: tmb [mailto:topmailbox@;yahoo.com] > Inviato: venerd́ 8 novembre 2002 13.18 > A: [EMAIL PROTECTED] > Oggetto: 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 all the tables & sql > statements in MySQL and then export the MS Access data > to a comma delimited file... then import it into > MySQL? > > Thanks for any help - tmb > > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
