Missing xml driver in Access

[Ironplow]

I reinstalled Access 3 times but it still doesn't have the ability to import
from an xml file. Where is the driver please? I tried re-registering
msxml.dll, but that didn't work.

(This is a re-post of a question I sent 5/7, but there was no response.)

Thank you for the earlier help with text and excel drivers.

 

[John Nurick]

Different versions of Access have different capabilities in this regard.
What version and service pack Access are you using, and what happens
when you try to import data from an xml file? Can you export data from
Access to xml? If so, can you re-import it?

 

[Ironplow]

I have made some progress and am now able to get the file to open, but the
data is not coming in. It just lists one record with two fields rather than
reading all the data in the xml file. I am running Access 2003 SP2. Can you
suggest a location for some xml examples?

 

[John Nurick]

I don't have much experience with XML, so I'd start with the Access 2003
help topic "About XML data and Access".

It's important to remember that Access can only handle a subset of XML
files; as the help topic says, you may need to use XSLT to transform the
data into a shape Access can manage.

 

[Tom Wickerath MDB]

yeah XSLT is nice

but I still think that MS should make the 'import XML' funcitionality a lot
stronger

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

yeah XSLT is nice

but I still think that MS should make the 'import XML' funcitionality a
lot stronger

 

[Tom Wimpernark]

Access Data Projects have a lot more XML functionality