Is it possible to walk through the XML data and extract it to a plain CSV
text file? If you can get rid of all the extraneous XML junk, you can do
almost anything you want. Word, Excel, and Access (and almost anything else)
can read a plain text file without the encumbrance of having to use an xlt
template.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Ed from AZ" wrote in message
ups.com...
Thanks for the reply, Arvin.

The main manipulation I would want to accomplish with this is moving
chunks of data from one file to another.

One of the Java forms is a grid-style data entry. There can be
multiple forms like this (these are "child" forms??) in one XML file.
The grid reminds me of an Access table in that the left column auto-
numbers, and several of the cells have drop-down lists. Within the
Java form grid, though, I can not copy rows, either singly or in a
block, to move to another XML file or even another child form in the
same file.

I have been able to accomplish this by opening the files in Word and
using cut and paste, but that doesn't seem like the best way to work
with a grid. This would work great in Excel, where I can simply copy
a hug block of rows and move them. If I had a template set up with
the drop-down validations to import this into, I could add new lines
and do a few other things as well.

As I said, I am unfamiliar with Access. I've managed to create a few
tables, queries, and generic forms and reports, but not really get
into a table and manipulate the information like this.

Where should I go to learn more about how to accomplish this?

Ed

On Nov 14, 7:29 am, "Arvin Meyer [MVP]" wrote:
You can easily export data from Access to Excel, but remember that the
data
in Access is relational, while Excel is a flat file. If you have
referential
integrity enforced, it won't be as simple as exporting then reimporting
back. Depending upon what you need to do, you may be able to do your
manipulation in Access. If you need an analysis tool, Excel is just the
ticket. For storing, manipulating, and retrieving large amounts of data,
Access is the best choice.
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

"Ed from AZ" wrote in
oglegroups.com...



(Windows XP Pro, Office 2003) I work with a Java-based program that
creates an XML file. Normally, we do not work directly with the XML
files. Sometimes, though, information needs to be transferred between
XML docs, and I've been trying to find a way to do that.

The Java program consists of forms to fill out, and some of them are
repeating, or child, forms. This is the data that I am most
interested it - seeing all the data for each of the child forms in a
group where I can edit, add, delete, etc as I wish.

When I try to open an XML file with Excel (either by right-clck on the
XML file and Open With or XL Data XML Import), Excel creates
a schema that doesn't present the information in a way I can logically
work with it. When I import the file into Access, thoguh, it creates
a separate table for each major section.

I am not familiar with Access, except to know that I can't manipulate
data in an Access table like I can in an Excel spreadsheet. I would
like to be able to get my XML data to import into Excel either as
separate worksheets for each major section or to be able to choose
just the one section to import and work with. Failing that, I'll
probably see about importing into Access, exporting the one table out
and Excel, working with it, importing that table back into Access, and
then saving the file.

Any pointers or suggestions would be greatly appreciated!

Ed- Hide quoted text -

- Show quoted text -