Posted by Michael Vilain on 08/03/07 18:27

In article
<vikr-74AA8C.10072803082007@earthlink.vsrv-sjc.supernews.net>,
Vik Rubenfeld <vikr@mindspring.com.invalid> wrote:

> In article <1186154359.579533.219220@x40g2000prg.googlegroups.com>,
> ELINTPimp <smsiebe@gmail.com> 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...

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[Back to original message]