MS Access ImportXML "DTD not allowed"

Asked Aug 22 '20 at 02:33

Active Aug 22 '20 at 02:43

Viewed 309 times

I'm trying to import an XML file into Access, but I get the

31593 error: DTD not allowed.

I understand that there are some lines in my xml that cause the fail, I test deleting those lines from my file and it works fine, but I need to know how to delete those lines in my VBA script because I download that xml and I don't want to delete those lines each time I import the files. I was trying t find out how to do this, maybe you can give me some idea about how to do it.

edited Aug 22 '20 at 02:43

zx485

28,498
28
50
59

asked Aug 22 '20 at 02:33

Maria del Pilar Fernandez Andr

So are you looking for a way to pre-process the XML file to remove the ` – Gord Thompson Aug 22 '20 at 16:58
1

Great, that is exactly what I just finishing to est and it works perfectly, thanks – Maria del Pilar Fernandez Andr Aug 22 '20 at 22:25

MS Access ImportXML "DTD not allowed"

0 Answers0