#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    13
    Rep Power
    0

    How do I export data from across several MS Access tables to XML


    Hi - I have been tasked to provide a supply company with a list of my orders in XML format for them to provide deliveries. The data I need to export from is held across several tables in a MS Access 2007 database. The XML tags I need to use are those provided by the supply company.

    What would be the best method, or set of tools, to use to provide what is required?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Jun 2007
    Posts
    1,513
    Rep Power
    1424
    Depends on the xml in use. In general, Access can export reports to XML. If that's not enough, VBA can access MSXML and DOM to create XML files from Access. I don't think, you'll need much tools for that, depending on the complexity of your data.

    Regards, Jens
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    13
    Rep Power
    0
    thanks for the reply Jens - is it possible you could point me to a decent tutorial or examples for doing this?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Jun 2007
    Posts
    1,513
    Rep Power
    1424
    Unfortunately I don't have anything in your language in my bookmarks, but with the given keywords, you should be able to find something using google.

    Regards, Jens
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    13
    Rep Power
    0
    Ok - thanks

IMN logo majestic logo threadwatch logo seochat tools logo