We have to import XML files with some child elements into a table in Ms Access. Preferably in only 1 table, but it the data structure doesn't allow this, in more tables that are linked.
We would like to use the standard importXML functionality of MS Access and the transform option, using XSLT if possible.
The project is for 1 XML file. If this works well there will be more files for future projects.
As I'm new to importing XML files with child elements, advise on how to set this up using MS Access is welcome.
9 freelanceria on tarjonnut keskimäärin 72 $ tähän työhön
Please provide me sample XML file and MSAccess table structure so that I will create xslt file and provide to you for data trasformation. Please see PMB for more details.