当然可以了,步骤如下
1.在access导出数据,导出格式为text的,数据如下,导出方法见图
0,"yxyup"
1,"yxyup1"
2,"yxyup2"
2.binary方式ftp到msyql服务器上
3. 导入mysql
mysql> create table t1 (id int,name char(10));
Query OK, 0 rows affected (0.05 sec)
mysql> select * from t1;
Empty set (0.00 sec)
mysql> load data local infile '/tmp/t1.txt' into table t1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' ;
Query OK, 3 rows affected (0.00 sec)
Records: 3Deleted: 0Skipped: 0Warnings: 0
mysql> select * from t1;
+------+--------+
| id | name |
+------+--------+
|0 | yxyup|
|1 | yxyup1 |
|2 | yxyup2 |
+------+--------+
3 rows in set (0.00 sec)
[ 本帖最后由 yxyup 于 2008-4-25 17:39 编辑 ] |