Question

怎么把excel 里的数据导入DB2的table？

1，在DB2创建了table GLC, 里面有两个field
2，我现在把excel 另存为了csv，名字是GLC.CSV. 用import导入table时报错
有哪位高手帮忙看看啊？谢谢!!
SQL:

import from "C:\glc.csv" of del messages "c:\msg.out" insert into GLC

Error:
>[Error] Script lines: 1-2 --------------------------
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=import from "C:\glc.csv" of del messages "c;BEGIN-OF-STATEMENT;<space>, DRIVER=3.50.152
Message: An unexpected token "import from "C:\glc.csv" of del messages "c" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152 

若以下回答无法解决问题，邀请你更新回答

Answer 1

把路径引号去掉试试