Jump to content

XSLT to change XML in MS ACCESS import


n3c0

Recommended Posts

Hi,

I need to import the xml file into access and I should do the transformations (XML -> XML) and to do that Access calls an XSLT file.

Then my source file is as follows, of course I deleted the rows because it was very long, but it should be understood, however, the structure.

<?xml version="1.0" encoding="ISO-8859-1" ?> <Title> <File>nomefile.xml</File> <Date>2014-05-23 11:37:41</Date> <A> ... </A> <B> ... </B> <C> <D Index="1"> ... </D> <D Index="2"> ... </D> <D Index="3"> ... </D> </C> </Title>

Importing it into MSAccess, it creates several tables for each element and so far everything is ok.

I would like to have in each table the element "data" (which the original xml is reported only in a table).

Then there is the problem of "index" which are not always 3, may be more or less, and even in this case would need the date in each element ...

Who can help me to generate an XSLT that meets my needs? I hope I have explained my problem clearly

thanks

Link to comment
Share on other sites

  • 1 month later...

Start small, use the w3s online xml xslt editor to see result, while also viewing the code side by side. Do a fragment of the xml, and once that is accomplish. Expand it to your desire portion.

Link to comment
Share on other sites

Start small, use the w3s online xml xslt editor to see result, while also viewing the code side by side. Do a fragment of the xml, and once that is accomplish. Expand it to your desire portion.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...