We receive daily XML files via FTP. We need this data to be imported into MS Access in order to process it further.
The xml is of a rather simple structure. DTD available, as well as description of structure and fields. Testfile can be provided.
A script written in VBA which has as imput the xml and as output a number of Access tables.
- Not sure which of the two DTD's is the correct one
- The script should have some flexibility in picking up fields recognizable by 'extra_ . . ' in their name.