n3c0 Posted May 23, 2014 Share Posted May 23, 2014 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 More sharing options...
L8V2L Posted June 29, 2014 Share Posted June 29, 2014 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 More sharing options...
L8V2L Posted June 29, 2014 Share Posted June 29, 2014 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now