The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...
You could also use XSLT to make an intermediate file for you and then use that file to actually load your database. IMO, what I'd pick would be dependent upon how complex the incoming XML was and how ...