[plug] Help on Importing Access DB into MySQL

[Jason Bainbridge]

Haven't had any experience with Access --> MySQL, but have done some SQL 
Server --> MySQL and a quick google turned up some similar tools wth most of 
them listed at MySQL's site:

http://www.mysql.com/portal/software/html/software-37-1.html

The best free alternative unfortunately looks like a program written in German 
(that is unless you speak German):

http://www.mdb2mysql.de/

With MSSQL conversion the tool I use is a VBA script someone wrote that uses 
ODBC to automagically create the database structure and transfer the data 
across. 

I don't think you'll be able to do something like save the *.mdb on a linux 
box and do the conversion, you'll either need to create a dump file on the 
windows box and then import it under linux or use ODBC to do it over the 
network.

-- 
Jason Bainbridge
KDE - Conquer Your Desktop
The KDE Usability Project - http://usability.kde.org
http://kde.org - webmaster at kde.org

On Wed, 18 Sep 2002 20:18, Steege, Phil E wrote:
> I am trying to bring all my office work over to Linux.
> I read an article on importing Access DB's into MySQL, under Windows, using
> ODBC at this link http://viaverio.com/support/virtual/mysql/odbc/
>
> It seemed to be showing how to take Access databases on a windows machine
> and export them to mysql databases on the same windows machine.
>
> I want to be able to bring over an access mdb file and import that straight
> into a mysql database on my linux box.
>
> Is that possible, or do I have to have a running access database on a
> windows machine (I have one on my network) and then export to my linux box
> across my network using ODBC ?