Can you not do it in CF? It'll probably be the easiest way to do it.
162934 rows isn't that many. But I guess the XML file size produced depends
on your data.
Give the following a crack:
<cfquery name="myQuery">
SELECT * FROM myTable
</cfquery>
<cfsavecontent variable="myXML">
<root>
<cfoutput query="myQuery">
<my-first-col>#myQuery.myFirstCol#</my-first-col>
<my-second-col>#myQuery.mySecondCol#</my-second-col>
<my-third-col>#myQuery.myThirdCol#</my-third-col>
</cfoutput>
</root>
</cfsavecontent>
Adrian
http://www.adrianlynch.co.uk/
-----Original Message-----
From: marc -- [mailto:[EMAIL PROTECTED]
Sent: 25 May 2008 11:55
To: CF-Talk
Subject: Convert Access to XML
Hi
I have an access db with 162934 rows and some 30 columns. I need to convert
it to XML.
Does anyone have any tips/comments on the best approach?
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306032
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
