Calculated field gets truncated during XML Export of a query

[drew]

I am exporting a query to XML using the "adPersistXML" format. This
works really well except one (calculated) field keeps getting
truncated. Is there a way to force the size of the field to be larger
than 255 characters when exporting the recordset?

The reason for doing this in VBA is because the regular Export Data
from the File Menu saves the XML in the wrong format (I need to be able
to bring it into a dynamic Web page using ADO recordset).

Here is the code I am using to save the recordset...

_____________________
With rst
.Open StrQryname, conn, adOpenDynamic, adLockOptimistic
.Save strFilename, adPersistXML
.Close
End With
_____________________

Thanks,
Drew

 

[John Nurick]

Hi Drew,

I've never used ADODB.Recordset.Save, but there's a long-standing bug
that truncates calculated fields at 255 characters when exporting (see
http://support.microsoft.com/?id=207668 for description and work-round).