- 博客(2)
- 收藏
- 关注
原创 [VBA]读取文件常用的方法(ADODB.recordSet|ADODB.stream)(大文件读取&指定encode)
'#####serach big file (ADODB.Recordset) →it is fast#####Sub searchLineFromText() Dim CN As ADODB.Connection Dim RS As ADODB.Recordset Dim rsList As Collection Dim tempStr As String
2016-03-13 23:19:18 7271
原创 vba_WriteToTextFile_ADO
Sub WriteToTextFile(FileUrl, mylist As Collection, CharSet) Set Stm = CreateObject("adodb.stream") Set b = CreateObject("ADODB.Recordset") 'MsgBox (Stm.EOS()) Stm.Type = 2 Stm.Mode = 3
2015-12-29 23:53:41 512
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人