convert ms access mdb file to file that can be imported in mysql
Hi, I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. Is there a tool available that converts an existing ms access db-file (*.mdb) into something that can be imported into mysql? I don't care about synchronising the two databases, running queries from different platforms, converting forms and/or queries. All I would like to extract the data from the .mdb file and store it in a mysql table. Preferably without having to install MS Access first. Thanks in advance, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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
Re: convert ms access mdb file to file that can be imported in mysql
you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. Andy - Original Message - From: Mertens Bram [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 4:17 PM Subject: convert ms access mdb file to file that can be imported in mysql Hi, I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. Is there a tool available that converts an existing ms access db-file (*.mdb) into something that can be imported into mysql? I don't care about synchronising the two databases, running queries from different platforms, converting forms and/or queries. All I would like to extract the data from the .mdb file and store it in a mysql table. Preferably without having to install MS Access first. Thanks in advance, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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 - 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
Re: convert ms access mdb file to file that can be imported in mysql
Andy, ( mysql, query ) you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. You have missed his point. He's asking Microsoft to support MySQL as a native backend. YEAH RIGHT I'd suggest the original asker rephrase his question into something a little more useful... DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - 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
Re: convert ms access mdb file to file that can be imported in mysql
On Sat, 2002-08-31 at 17:59, David Lloyd wrote: ( mysql, query ) You have missed his point. He's asking Microsoft to support MySQL as a native backend. I'm sorry if I was unclear, I'll try to clarify. I created a db under Windows using Access, I backed the .mdb files up. I have upgraded my OS to Linux. :) And my dbm to mysql, I do have Win98 installed on a separate partition but I haven't reinstalled Access or any other Office program and would like to know if it is possible to use a LINUX tool or program (I don't mind installing software, I just would prefer not to install any software under Windows) to convert the .mdb file into something I can use under Linux as input for my mysql db. I'd suggest the original asker rephrase his question into something a little more useful... Is this more useful? And an additional question: if the files can only be read/altered under Windows wouldn't it be easier to install Access and export the data to a text-file? I do believe Access offered that possibility,or doesn't it? BTW the Office version I could install is 2000. rant And finally: I wouldn't want Microsoft to support mysql in any way, they have a bad habit of 'improving' other software. In the process rendering it useless for everybody not willing to upgrade to the last version of their OS. /rant so again, thanks in advance for suggestions! Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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
RE: convert ms access mdb file to file that can be imported in mysql
I can supply a converter that will do this without having Access installed. Contact my Sales Manager Joy Johnson at [EMAIL PROTECTED] who will let you have a copy for £30.00 plus VAT (If in the EU) Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin Luxembourg -Original Message- From: Mertens Bram [mailto:[EMAIL PROTECTED]] Sent: 31 August 2002 17:20 To: mysql mailing list Subject: Re: convert ms access mdb file to file that can be imported in mysql On Sat, 2002-08-31 at 17:59, David Lloyd wrote: ( mysql, query ) You have missed his point. He's asking Microsoft to support MySQL as a native backend. I'm sorry if I was unclear, I'll try to clarify. I created a db under Windows using Access, I backed the .mdb files up. I have upgraded my OS to Linux. :) And my dbm to mysql, I do have Win98 installed on a separate partition but I haven't reinstalled Access or any other Office program and would like to know if it is possible to use a LINUX tool or program (I don't mind installing software, I just would prefer not to install any software under Windows) to convert the .mdb file into something I can use under Linux as input for my mysql db. I'd suggest the original asker rephrase his question into something a little more useful... Is this more useful? And an additional question: if the files can only be read/altered under Windows wouldn't it be easier to install Access and export the data to a text-file? I do believe Access offered that possibility,or doesn't it? BTW the Office version I could install is 2000. rant And finally: I wouldn't want Microsoft to support mysql in any way, they have a bad habit of 'improving' other software. In the process rendering it useless for everybody not willing to upgrade to the last version of their OS. /rant so again, thanks in advance for suggestions! Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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 - 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
