Import XML with Attributes

[Guest]

Can someone point me to how to do this? I have an application that is willing
to export a report in either xml or tab-delimited. I'm thinkin' XML-it-is!
Then, I realize the application puts out xml with attributes like column
names and types. It appears Access 2003 ignores them and does a very poor
import job. What should I do?

 

[Garry Robinson - Access MVP]

Given that you have to store this in a table, tidy up the table with
the correct data types and append the XML file into that. I like to
add the correct primary key so I don;t double load records and turn
number fields from text to numbers. You can also get fancy and use the
msxml object which gives you fantastic control over the xml.



Garry Robinson
Editor http://www.vb123.com.au