By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Importing MS Access into MySQL on Mac?

P: n/a
Is there a way to import an MS Access database .mdb file into MySQL
running locally on a Mac?

Thanks in advance to all for any info.
Aug 3 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Aug 3, 11:04 am, Vik Rubenfeld <v...@mindspring.com.invalidwrote:
Is there a way to import an MS Access database .mdb file into MySQL
running locally on a Mac?

Thanks in advance to all for any info.
This really isn't a PHP question, nor is it really a Mac-specific
problem. I will answer the question anyway, since I'm getting wings
for lunch and am therefore happy.

In my experience, the easiest way to import data from db to db is a to
dump the data in a delimited format and import into the new database.

http://dev.mysql.com/doc/refman/4.1/en/mysqlimport.html

There are articles out there about how to do it directly from Access
to MySQL...
http://www.google.com/search?source=...ql+import+data

But, like I said, I personally like dump and pull since I work on so
many different DB types.

Aug 3 '07 #2

P: n/a
In article <11**********************@x40g2000prg.googlegroups .com>,
ELINTPimp <sm*****@gmail.comwrote:
[...]
But, like I said, I personally like dump and pull since I work on so
many different DB types.
I hear you. After much googling and research, that is the approach I'm
taking. The reason I would like a more automated approach is that I'm
importing a database with 10 tables and many fields per table, and I
don't want any errors in terms of the field type, length, etc.

Every program I've found that directly imports MS Access to MySQL, runs
on Windows. Navicat runs on Mac, but the Mac version doesn't import MS
Access files.

If anyone's seen a Mac program that does this, please post a link to it.
Aug 3 '07 #3

P: n/a
Vik Rubenfeld wrote:
In article <11**********************@x40g2000prg.googlegroups .com>,
ELINTPimp <sm*****@gmail.comwrote:
>[...]
But, like I said, I personally like dump and pull since I work on so
many different DB types.

I hear you. After much googling and research, that is the approach I'm
taking. The reason I would like a more automated approach is that I'm
importing a database with 10 tables and many fields per table, and I
don't want any errors in terms of the field type, length, etc.

Every program I've found that directly imports MS Access to MySQL, runs
on Windows. Navicat runs on Mac, but the Mac version doesn't import MS
Access files.

If anyone's seen a Mac program that does this, please post a link to it.
You'll get a much better answer in a MySQL newsgroup, such as
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Aug 3 '07 #4

P: n/a
Michael Vilain wrote:
In article
<vi************************@earthlink.vsrv-sjc.supernews.net>,
Vik Rubenfeld <vi**@mindspring.com.invalidwrote:
>In article <11**********************@x40g2000prg.googlegroups .com>,
ELINTPimp <sm*****@gmail.comwrote:
>>[...]
But, like I said, I personally like dump and pull since I work on so
many different DB types.
I hear you. After much googling and research, that is the approach I'm
taking. The reason I would like a more automated approach is that I'm
importing a database with 10 tables and many fields per table, and I
don't want any errors in terms of the field type, length, etc.

Every program I've found that directly imports MS Access to MySQL, runs
on Windows. Navicat runs on Mac, but the Mac version doesn't import MS
Access files.

If anyone's seen a Mac program that does this, please post a link to it.

AFAIK, there is no such program since Access is a Windows-only
application. And the format is proprietary to Microsoft, so there's no
perl or other modules that can decode an Access database directly. Your
only option at this point is to automate dumping to a CSV file and write
a decoding script in perl or php to read such a file and load it into
MySQL. There's nothing on the Macintosh that can read it (same goes for
Publisher files).

So, it's time to go back to that drawing board...
Not at all - as he could find in a MySQL newsgroup...

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Aug 4 '07 #5

P: n/a
Vik Rubenfeld wrote:
Every program I've found that directly imports MS Access to MySQL, runs
on Windows. Navicat runs on Mac, but the Mac version doesn't import MS
Access files.
You'll probably get best results using Windows for this task. Obviously,
once it's on the MySQL server you can get at the data from any operating
system.

If you don't have a Windows system, you could try using OpenOffice.org
Base. OpenOffice.org (OOo) is a cross-platform office suite, and Base is
its database component. It is able to open Microsoft Access files, and
export them as comma-delimited or tab-delimited data files, which should
be fairly easy for you to import into MySQL.

An alternative, though more complicated to set up, probably easier in the
long run if you plan on transferring the data on a frequent basis, would
be to hook up OOo Base directly to the MySQL database using ODBC and write
a series of OOo BASIC scripts to run the data transfer automatically --
exactly how to do that is way beyond the scope of this newsground, but you
should be able to get support on the OOo web forums and mailing lists.

Unless they've changed their policies, OOo only officially supports
Windows, Linux and Solaris, but I frequently use it on my Mac (OS 10.3)
and it's perfectly functional. There's also a spin-off called NeoOffice
which integrates a bit better with Mac OS, though I find it a little
slower.

Hope that helps.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 44 days, 15:58.]

Command Line Interfaces, Again
http://tobyinkster.co.uk/blog/2007/0...nd-line-again/
Aug 4 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.