Hi,
You can create a XML file through
VB by executing the following script:
Dim Conn as new ADODB.Connection
Dim Rs as new ADODB.Recordset
Set Rs = Conn.Execute("SELECT * FROM TABLE_NAME")
Rs.Save Folder_Path & "\" & "XML_FILENAME.XML", adPersistXML
You can read a XML file through
VB by executing the following script:
Rs.CursorType = adOpenDynamic
Rs.LockType = adLockReadOnly
Rs.CursorLocation = adUseClient
Rs.Open XML_FILENAME, "Provider = MsPersist"
Rs.Sort = "Field ASC"
Hope this helps,
Lalit
Life Means More...;)