exporting to XML "gerald.ray[ at ]lexisnexis.com" <geraldray[ at ]lexisnexis.com> 08.06.2006 21:30:06 I noticed that you can export an Access database to XML, but is there anyway you can run it from a macro or a script. I want to automate the process on a nightly basis. thanx

Re: exporting to XML "Albert D.Kallal" <PleaseNOOOsPAMmkallal[ at ]msn.com> 08.06.2006 21:59:07 I assume access 2003? Check out the application.ExportXML acExportTable While in the code editor, go help...and type in ExprotXML You will find information on the ExprotXML feature.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal[ at ]msn.com http://www.members.shaw.ca/AlbertKallal

Re: exporting to XML "Sanjib Biswas" <sanjib.biswas[ at ]ieee.org> 15.06.2006 15:58:23 But keep in mind that exportXML will only export one table from the database. You will have to repeat export on all the tables in that database. And moreover each export of tables will be saved in separate xml files. "Albert D.Kallal" <PleaseNOOOsPAMmkallal[ at ]msn.com> wrote in message news:OU%23BJb0iGHA.4512[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] >I assume access 2003? > > Check out the > > application.ExportXML acExportTable > > While in the code editor, go help...and type in > > ExprotXML > > You will find information on the ExprotXML feature.... > > -- > Albert D. Kallal (Access MVP) > Edmonton, Alberta Canada > pleaseNOOSpamKallal[ at ]msn.com > http://www.members.shaw.ca/AlbertKallal >