Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Brazil
    Posts
    8

    Unanswered:

    thanks!!!

  2. #2
    Join Date
    Feb 2002
    Posts
    15

    Smile

    Hi all,
    I followed the intstruciton, but I always met with 'access denied' problem. I end up with another way. I export the access table into a txt file using (comma separated values) format, and import it into the table in a MySql database(you have to create table with the same schema). After invoking the 'mysql' program, input a 'LOAD DATA' command to import the file.

    mysql> mysql mydb
    mysql> LOAD DATA LOCAL INFILE 'xxx.txt'
    -> INTO TABLE tablename
    -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    -> LINES TERMINATED BY '\r\n';

    Done! It works fine. I think it can only be applied in small-scale migration.(without too many tables)

    Hope that helps,

    TC Wang 03/04/2002

  3. #3
    Join Date
    Jan 2002
    Posts
    11
    I use MySQLFront to do it for me..

    http://www.mysqlfront.de/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •