I'm having the hardest time importing an XML file into Access 2007. It's a Classifieds feed for a newspaper. They are grouped as <AD></AD>.
Not all of the fields are pulling in. The fields will pull in when each of the ads are run seperately. But in one big file, or even two ads together, Access will not pull all of the fields.


Does anyone have an idea of why that may be?