e.Form.Controls("TextBox1").text = ClipBoard.GetText()
If e.Form.Controls("TextBox1").text <> ""
Dim s As String = e.Form.Controls("TextBox1").text
s = s.Replace(vbcrlf & " ","").Replace(vbcrlf,";").Replace(Chr(13) & " ","").Replace(Chr(10),"").Replace(Chr(13),";") '规范条件按格式
Dim clname As String = "Contact_Name,Address,Zip_Code,Mobile,No,第六列,第七列,第八列,第九列,第十列"
Dim Value1s(),Value2s() As String
Value1s = s.split(";")
Value2s = clname.split(",")
Dim dr As Row = Tables("客户订单表").AddNew()
For Index As Integer = 0 To Math.Min(Value1s.Length,Value2s.Length) - 1
dr(Value2s(Index)) = Value1s(Index).Replace(Value2s(Index).Replace("_"," ") & ":","").Trim(" ")
Next
End If
msgbox("添加成功")