Results 1 to 2 of 2
  1. #1
    opopanax666 is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    27

    Export to XML using existing XSD

    Hi everyone,

    I work for a non-profit organization that receives subsidies from the goverment for the people we employ. Up until now we had to report how many hours each of these people worked on paper.
    But now the goverment has decided to switch to a web based reporting tool. There is a choice between input through a web interface or uploading an XML-file.
    Using the web interface (and the way it has been implemented) would mean it would take several days for one person to input all the data, which I find unacceptable.
    So I'm trying to make the XML-thingy work, but having no previous experience with XML this proves to be a difficult task, to say the least.
    I understand the basic use of XML in this case, but it's the implementational side I don't get.
    The only "help" I found was a XSD scheme (see attached file), which discribes a 3-tier tree (see attached pic), but have found no obvious way of using it.
    I can take care of the input-form, and the necessary table(s) myself, but need help with the conversion...



    If anybody could give me a hand, I would appreciate.

    TIA,
    James
    Attached Thumbnails Attached Thumbnails xml-tree.jpg  
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,594
    If the Access export wizard won't generate the XML file in the required structure then use VBA code to write to text file. An XML file is a textfile that can be read by any text editor, Notepad works.

    Here is one link discussing code to open, read, write to text file: http://www.databasedev.co.uk/text_files.html

    That XSD file is also a text file that can be opened with Notepad. The Access export wizard has option to create XSD as well as the XML. Not sure what the XSD file is for.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. how export and replace existing file
    By sk88 in forum Access
    Replies: 6
    Last Post: 10-01-2012, 12:55 PM
  2. Replies: 11
    Last Post: 05-23-2012, 08:42 AM
  3. export query into existing workbook
    By hklein in forum Programming
    Replies: 3
    Last Post: 05-08-2012, 04:55 AM
  4. How can i know existing period
    By waqas in forum Forms
    Replies: 1
    Last Post: 09-19-2011, 11:36 AM
  5. Replies: 0
    Last Post: 02-25-2011, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums