there is an app called sqlyog it imports access directly into mysql

-----Original Message-----
From: SpamBox [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:13 AM
To: Robert Morgan; mysqllist
Subject: Re: importing Access databases


Robert Morgan wrote:

>Hi, I'm doing a project for a local hospital, they want to migrate their
access databases to mysql on a Linux box. The hospital runs a Windows
network and I have MYsql running on a linux box connected to the network. I
need to import the Access .mdb data and structure from the windows server to
MYsql, all this has to be done from the Linux box. I have heard of some
programs that can do this but they seem to be for mysql on windows or for
windows clients (Mysqlyog, dbtools ) I am a newbie when it comes to
linux-MYsql.
>Any help appreciated.
>
>Running Redhat 9 and the MYsql version that comes bundled with it.
>
>
>
There is 'mdbtools' on sourceforge, which allows you to view data in an
MDB file and export it.
I would not go about it this way though. I would create the tables in
MySQL - paying close attention to field types, and then link the MySQL
tables to Access via the MyODBC driver, and then use queries to dump the
data from the Access tables into the MySQL tables. Alternatively, you
could export the data to a CSV file and use 'load data infile' on the
MySQL server to import the data. But linking the tables in Access is
easier...

Dan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to