MS Access 2003 and Exporting in a XML Format
-
I have a series of tables in MS Access 2003 and would like to export a subset of the data out in an XML format. I have come accross the Application.ExportXML facility in MS Access 2003, but is this applicable if I need to export 2 fields from Table A, 3 from Table B and 1 from Table C. My question is, should I write a VBA module to export the data I require or are they an example on how to use Application.ExportXML in the way required. I cant find much documentation on this facility. Sorry if this is the wrong forum. Many thanks
-
I have a series of tables in MS Access 2003 and would like to export a subset of the data out in an XML format. I have come accross the Application.ExportXML facility in MS Access 2003, but is this applicable if I need to export 2 fields from Table A, 3 from Table B and 1 from Table C. My question is, should I write a VBA module to export the data I require or are they an example on how to use Application.ExportXML in the way required. I cant find much documentation on this facility. Sorry if this is the wrong forum. Many thanks
Create a query containing your required fields then use Application.ExportXML with the query as your DataSource. Application.ExportXML _ ObjectType:=acExportQuery, _ DataSource:="YourQuery", _ DataTarget:="Path\YourFile.xml" The above shows the required properties. For a list of additional (optional) properties, see the Access 2003 help file for the ExportXML method. Steve