Importing MS Access into MySQL on Mac?

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.

Re: Importing MS Access into MySQL on Mac?

On Aug 3, 11:04 am, Vik Rubenfeld wrote:
> 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=ig&hl=en&q=mysql+import+ data

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

Re: Importing MS Access into MySQL on Mac?

In article <1186154359.579533.219220@x40g2000prg.googlegroups.com>,
ELINTPimp wrote:

> [...]
> 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.

Re: Importing MS Access into MySQL on Mac?

Vik Rubenfeld wrote:
> In article <1186154359.579533.219220@x40g2000prg.googlegroups.com>,
> ELINTPimp wrote:
>
>> [...]
>> 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.
jstucklex@attglobal.net
==================

Re: Importing MS Access into MySQL on Mac?

Post removed (X-No-Archive: yes)

Re: Importing MS Access into MySQL on Mac?

Michael Vilain wrote:
> In article
> ,
> Vik Rubenfeld wrote:
>
>> In article <1186154359.579533.219220@x40g2000prg.googlegroups.com>,
>> ELINTPimp wrote:
>>
>>> [...]
>>> 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.
jstucklex@attglobal.net
==================

Re: Importing MS Access into MySQL on Mac?

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/08/02/command-line-again/