в 16:33, 26 мая 2010

2010-05-26T16:33:00Z

Admin: 1 версия

2010-05-26T12:47:13Z

1 версия

Новая страница

==Exporting an Access Report to an XML Data File with ASP==



<source lang="vb">

Sub Export_InvoiceReport()
Application.ExportXML ObjectType:=acExportReport, _
DataSource:="Invoice", _
DataTarget:="C:\Invoice.xml", _
PresentationTarget:="C:\Invoice.xsl", _
ImageTarget:="C:\Learn_XML", _
WhereCondition:="OrderID=11075"
End Sub
</source>

==Exporting Multiple Tables to an XML Data File==



<source lang="vb">

Sub Export_CustomerOderDetails()
Dim objOtherTbls As AdditionalData
On Error GoTo ErrorHandle
Set objOtherTbls = Application.CreateAdditionalData
objOtherTbls.Add "Employees"
objOtherTbls.Add "Products"
Application.ExportXML ObjectType:=acExportTable, _
DataSource:="Customers", _
DataTarget:="C:\Details.xml", _
AdditionalData:=objOtherTbls
Exit_Here:
Exit Sub
ErrorHandle:
MsgBox Err.Number & ": " & Err.Description
Resume Exit_Here
End Sub
</source>

← Предыдущая	Версия 16:33, 26 мая 2010
(нет различий)

VBA/Excel/Access/Word/XML/XML Export - История изменений

в 16:33, 26 мая 2010

Admin: 1 версия