MySQL导入Access数据

1. 从access中导出数据为文本格式。

2. 编码转换,可用vs.net

3. Load Data InFile 'E:/temp/GeoConcepts_plus1.txt' Into Table `geoconcepts`Fields Terminated By ',' Enclosed By '$' Escaped By '$' Lines Terminated By '\r\n';

posted @ 2012-05-14 00:55  iLocationStudio  阅读(158)  评论(0编辑  收藏  举报