Import ONIX XML into MS Access

We receive inventory data via ONIX XML files with daily updates via FTP. We need this data to be imported into MS Access It is our impression that MS Access is able to import the ONIX XML file, but that the resulting tables within MS Access are not related correctly. Therefore the assignment could also be regarded as 'preparing/parsing the ONIX XML so that it can be imported in MS Access'. Deliverable: A script, preferably written in VBA, which enriches the ONIX XML so that it can be imported in MS Access. Open to other suggestions however to achieve the retired result. For the ONIX format please refer to the internationally set format.