Dim strTemp As String, strYpinf() As String
strTemp = "010000A8900016F000169DC0 可口可乐"
'置换分隔符,以适用各种情况
If InStr(strTemp, vbTab) Then
strTemp = Replace(strTemp, Space(1), "")
Else
'去除多余的空格
Do Until InStr(strTemp, Space(2)) < 1
strTemp = Replace(strTemp, Space(2), Space(1))
Loop
strTemp = Replace(strTemp, Space(1), vbTab)
End If
strYpinf = Split(strTemp, vbTab)
rs.Open "SELECT * FROM ypinf WHERE 药品EPC码='" & strYpinf(0) & "'", cnn
Text1 = rs.Fields("药品EPC码")
Text2 = rs.Fields("药品名称")