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