I use Access to update a series of ~300 files between ~20 databases which I built/maintain the back end of, but the end users who operate the database are novice at best when it comes to anything tech related. This has been working great for the exports I am allowed to submit in CSV or XLSX, but now I need to tackle the large chunk of exports that must match a specific XML template on export. I can import XML fine, but I am struggling to get it back into the exact same XML format ~100 times without needing the user to know how to manually update files. Currently I have the export in CSV and the user just copies and pastes the column into the XML file, but now we are at a point where we are talking about doing that for ~100 files a week. It's not pretty. The XML file format I need to match has set text in the first 7 rows that needs to remain consistent each time and has nothing to do with updates in the database. Row 8 is the field names and the remaining rows are the export of what the database is updating. I should also add that VBA isn't my comfort zone but willing to work on it with guidance. Any help is appreciated! I've been researching this a lot of and coming up with nothing.
asked Dec 13, 2020 at 20:39 Jessica Gordon Jessica Gordon 11 2 2 bronze badges Does this answer your question? Exporting Access Table into XML using VBA Commented Dec 13, 2020 at 20:58 Commented Dec 14, 2020 at 1:16If an xlst file can't work, alternative is writing strings to text file vbahowto.com/how-to-generate-a-xml-file-with-access-vba