Posted by Jerry Stuckle on 08/04/07 00:12

Michael Vilain wrote:
> 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...
>

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
==================

[Back to original message]