Dim sr As TextStream
Dim fileStr As String
Dim fso As New Scripting.FileSystemObject
CommonDialog1.ShowOpen
fileStr = CommonDialog1.filename
If fileStr = "" Then
MsgBox ("未选择文件,不能导入数据!")
Return
End If
If Not fso.FileExists(fileStr) Then
MsgBox ("文件 " & fileStr & "未找到或格式不正确!")
Return
End If
' Dim FILE_NAME As String = fileStr
Set sr = fso.OpenTextFile(fileStr)
'
' Dim sr As TextStream
Dim InputStr As String
Dim FieldsStr(35) As String '
Dim StrCode As String
Dim I As Integer
I = 0
InputStr = sr.ReadLine
' Open fileStr For Input As #1
While Not InputStr() = ""
InputStr = sr.ReadLine
If InputStr = "" Then
GoTo 90
End If
FieldsStr = Split(InputStr, ",")
'取得数组
' Try
If I = 0 Then
......
End If
End If '插入条码信息
.......
90:
MsgBox ("记录导入成功!")
Dim fileStr As String
Dim fso As New Scripting.FileSystemObject
CommonDialog1.ShowOpen
fileStr = CommonDialog1.filename
If fileStr = "" Then
MsgBox ("未选择文件,不能导入数据!")
Return
End If
If Not fso.FileExists(fileStr) Then
MsgBox ("文件 " & fileStr & "未找到或格式不正确!")
Return
End If
' Dim FILE_NAME As String = fileStr
Set sr = fso.OpenTextFile(fileStr)
'
' Dim sr As TextStream
Dim InputStr As String
Dim FieldsStr(35) As String '
Dim StrCode As String
Dim I As Integer
I = 0
InputStr = sr.ReadLine
' Open fileStr For Input As #1
While Not InputStr() = ""
InputStr = sr.ReadLine
If InputStr = "" Then
GoTo 90
End If
FieldsStr = Split(InputStr, ",")
'取得数组
' Try
If I = 0 Then
......
End If
End If '插入条码信息
.......
90:
MsgBox ("记录导入成功!")
解决方案 »
- 关于注册表问题的一个疑惑
- feiyun0112 帮我解决了问题
- 如何才能找出窗口标题包含有“STUDIO”字样的窗口?
- 请问vb6.exe产生出错的错误日志去哪里查?
- 怎样把一个form窗体放到一个form窗体的前面(在线等)
- 对隐藏窗体内指定坐标截图
- ADO,dim rs as adodb.recordset / rs=cn.execute(str) / rs.movelast, rs.moveprevious 报错说不支持。我想可能需要将游标类型设为动态,
- 在VB的IDE里有没有将选中的代码注释这个功能?
- excel 运行无法加载DLL库
- VB6.0使用ADO创建数据库,中文字段排序出现问题
- dll中能创建多线程吗?急!!!!
- 怎样去掉MDI最大化时的动画
这时错误了!
建议你改正
是不能把字符串类型给数组类型赋值错误!
FieldsStr = Split(InputStr, ",")这里写错误了FieldsStr是数组类型的,
InputStr这个是字符串类型的
像这个FieldsStr数组类型的,InputStr字符的
会出现类型不匹配的错误
FieldsStr = Split(InputStr, ",")
Dim FieldsStr(35) As String → Dim FieldsStr() As String
不是这里的错
Dim FieldsStr() As String '改这一句
FieldsStr = Split(InputStr, ",")
这是怎么改呀!还不是一样没改!