This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Microsoft XML > May 2005 > NEWBIE - Access Query to XML Files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
NEWBIE - Access Query to XML Files
|
|
| Jason Buck 2005-05-25, 7:55 pm |
| Hello all,
XML Newbie here. I am using Access 2003 and I would like to export each
recordset in a query to a separate XML File.
How can I do this using VBA, or ASP?
Thanks in Advance,
| |
|
| Maybe,
rs.open sql, con, 0, 1, 1
set xmldoc=createobject("msxml2.domdocument")
rs.save xmldoc, 1
' and debug according to your dev't environment
msgbox xmldoc.xml
or
response.contenttype="text/xml"
xmldoc.save response
--
Pohwan Han. Seoul. Have a nice day.
"Jason Buck" <Jason Buck@discussions.microsoft.com> wrote in message
news:74474D24-5A55-4BE6-85A7-20446438BEC0@microsoft.com...
> Hello all,
> XML Newbie here. I am using Access 2003 and I would like to export each
> recordset in a query to a separate XML File.
>
> How can I do this using VBA, or ASP?
>
> Thanks in Advance,
>
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|