append from解决思路

append from2006-06-06|Meeting re status of pending matters.|Poakeart, JA|0.03|240.00|7.20上面一行以

append from
2006-06-06|Meeting re status of pending matters.|Poakeart, JA|0.03|240.00|7.20

 上面一行以 | 导入表中,append form tt.txt deli with '|' 怎么补管用呢

[解决办法]
有无全角、半角符号问题?
append form tt.txt deli WITH CHARACTER '|'
[解决办法]
字符串的值,要加引号