日志
XML與ADODB.Recordset
|
CODE:
Public Function ReadXml(xmlFile As String) As ADODB.Recordset
Dim rs As New ADODB.Recordset
rs.Open xmlFile, "Provider=MSPersist", , , adCmdFile
Set ReadXml = rs
Set rs = Nothing
End Function
Public Sub SaveXml(sql As String, xmlFile As String)
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Set conn = CurrentProject.Connection
rs.Open sql, conn, adOpenKeyset, adLockReadOnly
rs.Save xmlFile, adPersistXML
Set rs = Nothing
Set conn = Nothing
End Sub
Private Sub DelFile(xmlFile As String)
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(xmlFile) Then
fso.DeleteFile xmlFile
End If
Set fso = Nothing
End Sub
Sub ReadXmlTest()
Dim strXmlFile As String
Dim rs As New ADODB.Recordset
strXmlFile = "C:\Test.xml"
Set rs = ReadXml(strXmlFile)
Do While Not rs.EOF
Debug.Print rs("帳目編號(hào)")
rs.MoveNext
Loop
End Sub
Sub SaveXmlTest()
Dim strXmlFile As String, strSQL As String
strSQL = "SELECT * FROM 帳目;"
strXmlFile = "C:\Test.xml"
DelFile strXmlFile
SaveXml strSQL, strXmlFile
End Sub用這樣的方法，我們可以持久保存ADODB.Recordset，也可以替代臨時(shí)表使用。 
點(diǎn)名卡
救生圈
時(shí)空機(jī)
熱點(diǎn)燈
變色卡