I have several xml files (100's) in a folder.
The location of the files is C:/My Documents/The_Files/.
The location of the database to where the data needs to be imported is C:/My Documents/The_Database/.
I would like to be able to import these XML files into an access table called "Extracted_Data". I have research various blogs and potential solutions on here, but I cannot seem to apply any to my needed solution. I am familiar with VB but far from an expert. I am working with MS Access 2010.
When I perform the import manually, there are several tables that are imported into the database, but the main table with all pieces of information I need is called "Needed".
Would anyone be able to script a code that could upon execution, import all of these xml files onto the one single table in access? Is there any additional information needed from me to help?
Thanks in advance,