Doesnt access have a 'save to XML' function? If not, Excel and SQLServer do.
So you could either export it to a humungous Excel file, give it a named range and save the range to XML format or you could export it to a SQLServer table, then use SELECT FOR XML to create your XML that way. Hope this helps. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, May 25, 2008 at 8:55 PM, marc -- <[EMAIL PROTECTED]> wrote: > 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:306030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
