急急!!CSV文件 现在有一个从EXCEL转变过来的CSV文件,我想读取它。怎么做,谢谢。最好有例子,第一次做这个东东。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 open "test.csv" for input as #1如果用记事本打开,也就是些文本而已。 FF = FreeFile Open myfileName For Input As #FF Do While Not EOF(FF) Line Input #FF, lineStr strRs = strRs & lineStr & CR DoEvents Loop Close #FF Private Sub Command1_Click() Dim strTmp As String, fPaht As String, strRlt() As String, i As Long fpath = App.Path & "\test.csv" strTmp = Space(FileLen(fpath)) Open fpath For Binary As #1 Get #1, 1, strTmp Close #1 strRlt = Split(strTmp, ",") '得到结果 For i = 0 To UBound(strRlt) Debug.Print strRlt(i) & vbCrLf '打印结果 NextEnd Sub 你的lineStr和strRs 是什么意思 csv文件是以逗号隔开各个数据的,我上面的代码是读文件,然后把各个数据读到数组strRlt里 求助:8086CPU字节数 100分高难:如何修改webbrowser中已经显示出来的网页中的代码? 如果取得本地连接的名称和IP VB连接网络SQL问题? 如何在VB中执行SQL脚本 困扰很久,连老外都无法解决的问题求助(在VB程序中设置IE的代理服务器) 关于创建对象-清高手指点 用winsock传输文件后,只能打开txt文件,doc文件无法打开,高手帮帮忙,谢谢! 问个弱弱的问题 如何修改网卡物理地址 求救ing.......... 关于Adodb.Stream
open "test.csv" for input as #1
如果用记事本打开,也就是些文本而已。
Open myfileName For Input As #FF
Do While Not EOF(FF)
Line Input #FF, lineStr
strRs = strRs & lineStr & CR
DoEvents
Loop
Close #FF
Dim strTmp As String, fPaht As String, strRlt() As String, i As Long
fpath = App.Path & "\test.csv"
strTmp = Space(FileLen(fpath))
Open fpath For Binary As #1
Get #1, 1, strTmp
Close #1 strRlt = Split(strTmp, ",") '得到结果
For i = 0 To UBound(strRlt)
Debug.Print strRlt(i) & vbCrLf '打印结果
Next
End Sub