Saving XML using rs.save using adPersistXML

[Harish]

Hi,

I had posted this problem some time back. I am saving a recordset to a XML
file. the table is a very simple Access table. i am using the following syntax.

rs.save "c:\file.xml", adPersistXML

However when I open the file, I get the following kind of data in the file


TG!  ¶’ò?²Ï�# ª _þX
! Ò*cöëÏ°ã ª ?    ÿÿÿÿ@
 ¾"µÈó\Î*å ª Dw=   †  I  Á<Ž¶ëmÐ�ö ª _þX / €



what is this '
TG!' ??? I can't get the recordset to save in XML format.
it is something to do with the microsoft ole db persistence service provider
?? I am working on w2k with MDAC 2.6 and MSXML parser 3.0. I don't know where
i am going wrong. please help..

Thanks
Harish

[Russell Jones]

You must define the constant adPersistXML or write the line like this:
rs.save "c:\file.xml", 1

The
TG! indicates that the Recordset data is ADTG format, not XML format.



"Harish" <harish@macro-soft.com> wrote in message
news:3a2f9002$1@news.devx.com...
>
> Hi,
>
> I had posted this problem some time back. I am saving a recordset to a XML
> file. the table is a very simple Access table. i am using the following
syntax.
>
> rs.save "c:\file.xml", adPersistXML
>
> However when I open the file, I get the following kind of data in the file
>
>
TG!  ¶'ò?²Ï�# ª _þX
! Ò*cöëÏ°ã ª ?   
ÿÿÿÿ@
>  ¾"µÈó\Î*å ª Dw=   ?  I  Á<Z¶ëmÐ�ö ª _þX / ?


>
> what is this '
TG!' ??? I can't get the recordset to save in XML format.
> it is something to do with the microsoft ole db persistence service
provider
> ?? I am working on w2k with MDAC 2.6 and MSXML parser 3.0. I don't know
where
> i am going wrong. please help..
>
> Thanks
> Harish