Anticlue

XML and Access 2002

TechRepublic has recently posted an article about Exporting Access into XML. I wonder if it also imports ..... I wonder if there is any handling of parent child relationships in the xml.

The great thing is this is functionality can also be coded into an application.

Application.ExportXML(objecttype, datasource[, datatarget][,
schematarget][, presentationtarget][, imagetarget][, encoding][,
otherflags])

Also snipped from the TechRepublic, here are the instructions on how to:

1. Select a table in the Database window?for this example, we'll export the Customers (a table in Northwind, the sample database that comes with Access) schema.


2. Select Export from the File menu.


3. Name the XML file CustomersSchema.


4. Select XML as the file type in the Save As Type control. Don't type the XSD extension; XML will assign the right extension.


5. Click Export and Access will display three export options; Data (XML), Schema Of The Data, and Presentation Of Your Data. The first two options are selected by default.


6. Choose Schema Of The Data; you're really just deselecting Data (XML).
   
7. Click the Advanced button. You should know that you can omit primary key and index information from the exported file.


8. Click the Data tab and click OK.

If you can import, this would really be a great tool for debugging hl7 version 3 transactions. Also for testing an interface, you could automatically have a series of xml transactions ready to go, and with a winsocket control, a port and IP address. This might be able to allow for standardized unit testing of developing interfaces without having to register, and create results time and time again