I have a large Access database which imports and analyzes Nessus results. I want to import nmap results into this database to fill in some of the gaps left by Nessus. Primarily the hostname, IP and MAC address.
When I implort the .usr file as an XML file into Access all the data is blank. I know that this is because the nmap is attribue vs element centric. I do not know XML and have been trying to use utilities to create a XSLT to trasform the import. So far I have not been successful in creating a workable transform.
Ideally I would like the transfom to select the three fields and copy the records into an Access table that contains just those three fields (Host Name, IP, MAC addr)