I need an XSL or XSLT file to transform an XML file for importation into MS Access.
When I import the attached file ([url removed, login to view]) into MS Access I get five separate tables (See [url removed, login to view]):
I need an XSL or XSLT file to transform the XML so it will import into one table (See [url removed, login to view]):
I DO NOT want code written to do this - I need the XSL or XSLT file to perform this transformation.
Here's an additional XML sample which includes more than one user record.
It would be acceptable to have a separate table for the Batch data since it only appears once in the XML file; however, I want all of the User data to be contained in one table.