Objective: To import multiple XML files into MS Access tables (Header+Elements) based on listed files in a separted Excel file
Dear Forumers,
In directory called 'Index', I have an excel spreadsheet containing a list of xml files (name + extension + source directory as path).
In different directories called 'XMLS_in_xxx', I have different xml's stored (name + extension) stored
I have designed a 'Header' table and an 'Element' table into my Access DB.
I would like to add a VBA script that can read my EXCEL files list and get each listed xml file from the indicated source path and store it in my Access tables (Header and Elements).
Can someone help please ?
Thanks in advance and regards,
MoBrussels