From: Jani Tolonen
Date: April 14 1999 3:00pm
Subject: How to export Access file to MySQL [Was Re: exporting big access file to mySQL]
List-Archive: http://lists.mysql.com/mysql/1837
Message-Id: <14100.44291.188129.197710@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Naresh Bhagtani writes:
 > What I'd like to know is how can I (what tools/scripts to use to) export
 > an Access table to a MySQL database.
 > 

Dear Naresh,

Save the data in your Access tables into a file, for example
tab delimited text file and use "load data infile" (mysqlimport) to
export data into MySQL.

Yours,

Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+