Export to XML - error 31532

O

Ohad

When trying to export a query/report to XML I recieve error 31532 "<database
name> was unable to export the data".

Exporting simple queries works fine, however when using even the most simple
JOIN within the query it fails with the error above (NOTE: the queries are
performed on linked Access database tables).

The reason I'm trying to export to XML is a workaround for access not being
able to export a report to excel - exporting to XML and opening the XML in
excel.

exporting the report's record source to excel is a good solution for me as
I'm using many calculated fields, grouping & filtering which I don't want to
re-code every time I change the report.

I tried with Access 2007 (12.0.4518.1014) & Access 2007 SP1 (12.0.6304.5000)
with no success.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

office link feature to excel in Access 2007 1
Access 2007 - Export to XML 1
Exporting data to xml file 3
XML Export of a table and related tables 1
How do I export a report to Excel in Access 2007 1
Export query to Excel fails 6
Access-->XML-->Excel: Size Limitations? 0
Export Roster to Excel - Losing Phone Format 1

Top