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