List:General Discussion« Previous MessageNext Message »
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]
View as plain text  
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   |
+---------------------------------------------------------------------+
Thread
exporting big access file to mySQL corrupts access DBJeffrey Mercer10 Apr
  • Re: exporting big access file to mySQL corrupts access DBwebmaster10 Apr
    • How to export Access file to MySQL [Was Re: exporting big access file to mySQL]Naresh Bhagtani12 Apr
      • How to export Access file to MySQL [Was Re: exporting big access file to mySQL]Jani Tolonen14 Apr