RE: MS: need your help Report Export
- From: "RobKaratzas" <RobKaratzas@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Aug 2005 12:03:05 -0700
OK, Access 2002 is broke...
Found a version of 2003 and it works fine.
rob
"RobKaratzas" wrote:
> 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.
>
.
- References:
- MS: need your help Report Export
- From: RobKaratzas
- MS: need your help Report Export
- Prev by Date: MS: need your help Report Export
- Next by Date: Re: export to excel converts text to scientific notation
- Previous by thread: MS: need your help Report Export
- Next by thread: remote linked tables
- Index(es):
Relevant Pages
|
