When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

I don't know if these will provide what you're looking for but may get u on
the right track.

desribes some Excel and Access XML and provides a VBA module to convert an
Excel file.
http://www.meadinkent.co.uk/xl_xml1.htm

and free web tutorials at:
http://www.w3schools.com/



"WalkToFreedom" wrote:

When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

"Brent E" wrote:


I don't know if these will provide what you're looking for but may get u on
the right track.

desribes some Excel and Access XML and provides a VBA module to convert an
Excel file.
http://www.meadinkent.co.uk/xl_xml1.htm

and free web tutorials at:
http://www.w3schools.com/



"WalkToFreedom" wrote:

When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

Thanks for your reply, but office 2003 does it natively I shouldn't have to
use a macro.

"WalkToFreedom" wrote:

When I saves as/export as XML it only saves one row as xml. How do
export/save all the rows as plain xml? I can't seem to assign the xml
mappings to more than one cell?

Thanks.

The answer is to use a schema that contains repeating information. I found
this link:

http://www32.brinkster.com/srisamp/n.../article_8.htm