Dim SQLStr
Dim IpRS As ADODB.Recordset
Dim iLoop As Integer
Dim MyxlsApp As New Excel.Application
SQLStr = "Select IP_ADDRESS,MAC_ADDRESS,PASSWD from Cc_IP "
Set IpRS = New ADODB.Recordset
IpRS.Open SQLStr, adoCon, adOpenStatic, adLockReadOnly
iLoop = 1
Do While Not IpRS.EOF
MyxlsApp.Cells(i_Loop , 1).Value = IpRS.Fields("IP_ADDRESS")
MyxlsApp.Cells(i_Loop , 2).Value = IpRS.Fields("MAC_ADDRESS")
MyxlsApp.Cells(i_Loop , 3).Value = IpRS.Fields("PASSWD")
IpRS.MoveNext
iLoop = iLoop + 1
Loop
set IpRs=Nothing
Dim IpRS As ADODB.Recordset
Dim iLoop As Integer
Dim MyxlsApp As New Excel.Application
SQLStr = "Select IP_ADDRESS,MAC_ADDRESS,PASSWD from Cc_IP "
Set IpRS = New ADODB.Recordset
IpRS.Open SQLStr, adoCon, adOpenStatic, adLockReadOnly
iLoop = 1
Do While Not IpRS.EOF
MyxlsApp.Cells(i_Loop , 1).Value = IpRS.Fields("IP_ADDRESS")
MyxlsApp.Cells(i_Loop , 2).Value = IpRS.Fields("MAC_ADDRESS")
MyxlsApp.Cells(i_Loop , 3).Value = IpRS.Fields("PASSWD")
IpRS.MoveNext
iLoop = iLoop + 1
Loop
set IpRs=Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货