Export XML

[RobKaratzas]

Hi Folks

Access is having problems (with a fully functional report) exporting it to
XML.

Neither a manual Report Export as XML works (nor does the manual effort):

Sub RptExport()
Application.ExportXML ObjectType:=acExportReport, _
DataSource:="MyReport", _
ImageTarget:=".", _
PresentationTarget:="MyReport.xsl", _
OtherFlags:=acPersistReportML
End Sub

1. Tried compact and repair (just fine)
2. Imported to an empty .MDB (just the table and report)
3. The module throws a:

'Run-time error '2950''

and the manual process gives me:

"Microsoft Access was unable to export the data"

This is critical for me, since I need to import the report into SQL Server
Reporting Services and this is a show-stopper.

Rob

 

[RobKaratzas]

OK, found a laptop with Access 2003 and the export works just fine.

Rob