Forum Discussion
Problems Importing XML Files Into Access
I'm trying to import several XML files into Microsoft access. When I use the XML import wizard however, access imports the XML file creating multiple tables, rather than a single table where each re...
Try using XSL transformation. To generate one, you can try https://www.easycodeforall.com/XSLTCode.jsp and enter your current and desired XML formats there. The generator will output the appropriate XSLT, which you can use when clicking the "Transformation"-Button in the Access Import Wizard.
