I feel like every few months I get the simplest of errors that my equally simple mind does not solve despite its best efforts.
Here is one such thing.
For one of my projects (handling confidential data), I have been given a set of 500+ XML files, all with similar information. each XML has 1000 rows of data. They are called 1.xml, 2.xml, etc. I need to get these data into MYSQL. I dont know why they had to split it into 500 files and all that, I have to just " shut up and load them into the DB".
Now, If I dont supress errors, nearly 1/3rd of the files err out with the following error:
The xml files are all in UTF-8 ( the header in each says
Nothing online talks about reading XMLs in UTF8 using vba.
I just have to do this ONCE for all the file to get one, clean excel sheet.