DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Access XP export to XML document

  1. #1
    Simon Guest

    Access XP export to XML document


    I am using Powerflow software (Electricity Network Powerflow Software)that
    creates one XML file of the entire network data/results. I have imported
    this XML file into Access XP. My intention is to change some of the data
    in Access XP before exporting back to an XML file and then importing the
    XML file back into the original Powerflow software.

    My problem is this:

    How do I export all the tables of data (and schema) from an Access XP database
    into an XML file? I am able to export one table at a time into different
    XML files, but the option to export more than one table into the same file
    is not available to me in Access XP.

    (nb. the MS help notes say that this option should be available, but I found
    an MS article Q283854 that states that the MS help is wrong and this functionality
    is not available yet)

    As you can probably tell my primary skill is in electrical engineering and
    XML is new to me. In this respect, I would very much appreciate any help/guidance
    that you can give.....and please, be gentle with your answers! :-)

    Regards,
    Simon




  2. #2
    Russell Jones Guest

    Re: Access XP export to XML document

    Simon:

    As you already have the data in XML, why do you need to put it into Access
    to modify the values and then change the Access tables back to XML? Without
    knowing more about what you're doing, it would seem to be simpler to modify
    the XML data directly through a DOM interface, (or for minor changes), with
    a text or XML editor. If that sounds reasonable to you, post some examples
    of your XML and what you're trying to do here.


    "Simon" <dsf@ee.ed.ac.uk> wrote in message
    news:3db53ca7$1@tnews.web.devx.com...
    >
    > I am using Powerflow software (Electricity Network Powerflow Software)that
    > creates one XML file of the entire network data/results. I have imported
    > this XML file into Access XP. My intention is to change some of the data
    > in Access XP before exporting back to an XML file and then importing the
    > XML file back into the original Powerflow software.
    >
    > My problem is this:
    >
    > How do I export all the tables of data (and schema) from an Access XP

    database
    > into an XML file? I am able to export one table at a time into different
    > XML files, but the option to export more than one table into the same file
    > is not available to me in Access XP.
    >
    > (nb. the MS help notes say that this option should be available, but I

    found
    > an MS article Q283854 that states that the MS help is wrong and this

    functionality
    > is not available yet)
    >
    > As you can probably tell my primary skill is in electrical engineering and
    > XML is new to me. In this respect, I would very much appreciate any

    help/guidance
    > that you can give.....and please, be gentle with your answers! :-)
    >
    > Regards,
    > Simon
    >
    >
    >




  3. #3
    Simon Guest

    Re: Access XP export to XML document


    Russell,

    Thanks for your quick response. I should perhaps elaborate more.

    I will be running network simulations at each 30minute segment for a full
    year. I will need to store the network data and results (which are considerable)
    for each of these simulations. Since this will produce a lot of data ( 48
    * 365 * X number of scenarios) I think a database is necessary to manage
    the data effectively. I will also need to carry out a considerable amount
    of statistical anaylsis on the data.

    I hope this helps fill in some of the background of where I am coming from.
    Again, any help you can give would be much appreciated.

    Regards,
    Simon


    "Russell Jones" <arj1@nospam.northstate.net> wrote:
    >Simon:
    >
    >As you already have the data in XML, why do you need to put it into Access
    >to modify the values and then change the Access tables back to XML? Without
    >knowing more about what you're doing, it would seem to be simpler to modify
    >the XML data directly through a DOM interface, (or for minor changes), with
    >a text or XML editor. If that sounds reasonable to you, post some examples
    >of your XML and what you're trying to do here.
    >
    >
    >"Simon" <dsf@ee.ed.ac.uk> wrote in message
    >news:3db53ca7$1@tnews.web.devx.com...
    >>
    >> I am using Powerflow software (Electricity Network Powerflow Software)that
    >> creates one XML file of the entire network data/results. I have imported
    >> this XML file into Access XP. My intention is to change some of the data
    >> in Access XP before exporting back to an XML file and then importing the
    >> XML file back into the original Powerflow software.
    >>
    >> My problem is this:
    >>
    >> How do I export all the tables of data (and schema) from an Access XP

    >database
    >> into an XML file? I am able to export one table at a time into different
    >> XML files, but the option to export more than one table into the same

    file
    >> is not available to me in Access XP.
    >>
    >> (nb. the MS help notes say that this option should be available, but I

    >found
    >> an MS article Q283854 that states that the MS help is wrong and this

    >functionality
    >> is not available yet)
    >>
    >> As you can probably tell my primary skill is in electrical engineering

    and
    >> XML is new to me. In this respect, I would very much appreciate any

    >help/guidance
    >> that you can give.....and please, be gentle with your answers! :-)
    >>
    >> Regards,
    >> Simon
    >>
    >>
    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center