|
|
Posted by Toby A Inkster on 08/04/07 12:35
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/
Navigation:
[Reply to this message]
|