Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: how to import .xls and .text files from

    Access 2000 to mysql 4.0.15?

    i am using MySQL-Front 2.5 as administrator tools.

    i have read many times manu of mysql,but i am still confusing.

    thanks a lot for any idea or hint!

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: how to import .xls and .text files from

    Originally posted by number100
    Access 2000 to mysql 4.0.15?

    i am using MySQL-Front 2.5 as administrator tools.

    i have read many times manu of mysql,but i am still confusing.

    thanks a lot for any idea or hint!
    for .xls files:
    1. download ODBC driver for MySQL from http://www.mysql.com
    2. Install and configure it
    3. In MS ACCESS import or make link to XLS file
    4. Create the same table in MySQL
    5. Make ODBC link to table in MySQL
    6. Create "append query" which select everything from XLS and insert to MySQL table


    for .txt LOAD DATA is the best solution

    http://www.mysql.com/doc/en/LOAD_DATA.html

Posting Permissions

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