str = "insert into tb1 (introd)vaule('"+str+"')";

[booming]

str = "insert into tb1 (introd)vaule('"+str+"')";
如果str有换行符号，发现在access2003中只能插入第一行。如何能插入str全部？

[WWWWA]

str内容

[booming]

比如我在access2003自带的查询sql中:

insert into tb1 (introd)vaule('aaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbb
ccccccccccccccccccccccccccccc');



这样的话,它就只会插入aaaaaaaaaaaaaaaaaaaaaa

[OracleRoob]

Dim strSQL As String

strSQL = "insert  into  tb1  (introd) values('aaaaaaa" & vbCrLf & _
    "bbbbbb" & vbCrLf & _
    "cccccccccc ')"

CurrentProject.Connection.Execute strSQL

[OracleRoob]

如果直接在查询中执行：

insert into tb1 (introd) values('aaaaaaaaaaaaaaaaaaaaaa 
bbbbbbbbbbbbbbbbbbbbbb 
ccccccccccccccccccccccccccccc');