Attempt to open XML file in Excel 2003 fails with error that "Required
whitespace was not found", together with a line and character reference. The
file is generated using the ADO recordset save to a stream object and then
the SaveToFile method of the stream - exactly as recommended on Microsofts
own web pages.

Why does the ADO software generate XML files that cannot be read by Excel,
Word or Access - is there a work round or a fix?

I've tried this with ADO 2.5, 2.7 and 2.8 - all the same

Sorry if this is the wrong forum - looks like the only one that fits.