G
Guest
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 module 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 single 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' (or spend dozens of hours
hand coding this).
Rob
PS If you are MSFT, I can send u the .MDB (Access 2002, SP-1) for inspection.
Access is having problems (with a fully functional report) exporting it to
XML.
Neither a manual Report Export as XML works (nor does the module 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 single 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' (or spend dozens of hours
hand coding this).
Rob
PS If you are MSFT, I can send u the .MDB (Access 2002, SP-1) for inspection.