sqlserver数据库?可以这样: select * from departments for xml auto最终查询的结果就是xml的格式了
以下直接将查询结果导出为xml格式的txt文件 EXEC master..xp_cmdshell 'bcp "select * from pubs..authors for xml auto" queryout c:\DT.txt -c -Syoki -Usa -P123456'
小马哥的第一个回答需要SQL2000以上版本。 我的一个办法是把记录读出来,保存成xml各式的文件。代码: Dim Conn As New ADODB.Connection Dim RS As New ADODB.Recordset Dim QueryString As String Dim XmlDoc As MSXML2.DOMDocument40 Conn.ConnectionString = ConnString Conn.Open Set RS = Conn.Execute(QueryString) 'On Error Resume Next Kill App.Path & "\output\rec.xml" RS.Save App.Path & "\output\rec.xml", adPersistXML然后你还可以用xsl文件来格式划他: XslDoc.async = False XslDoc.Load (App.Path & "\output\FormatFile.xsl")
select * from departments for xml auto最终查询的结果就是xml的格式了
EXEC master..xp_cmdshell 'bcp "select * from pubs..authors for xml auto" queryout c:\DT.txt -c -Syoki -Usa -P123456'
我的一个办法是把记录读出来,保存成xml各式的文件。代码:
Dim Conn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim QueryString As String
Dim XmlDoc As MSXML2.DOMDocument40
Conn.ConnectionString = ConnString
Conn.Open
Set RS = Conn.Execute(QueryString)
'On Error Resume Next
Kill App.Path & "\output\rec.xml"
RS.Save App.Path & "\output\rec.xml", adPersistXML然后你还可以用xsl文件来格式划他:
XslDoc.async = False
XslDoc.Load (App.Path & "\output\FormatFile.xsl")
XmlDoc.transformNodeToObject XslDoc, ResultDoc
On Error Resume Next
Kill App.Path & "\output\" & FileName & ".xml"
ResultDoc.Save (App.Path & "\output\" & FileName & ".xml")
rs.Save "d:\zz.xml", adPersistXML
rs.Close
Set rs = Nothing