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';