xml import

[Darth Vodka]

i feel a bit like Joe_ asking this...but anyhoo

i have an xml file and i'm trying to import it into Access/Excel

i would have thought this was quite simple, but either:-

a) it's complicated and i don't know how to get it in
b) it's bullshit and we need to tell IT that

file attached

i think it some many tables in a funny order, god knows, any advice is appreciated

 

[Macky]

Which version of Excel are you using?
I'm not 100% but I think only recent versions support XML files.

 

[Darth Vodka]

Which version of Excel are you using?
I'm not 100% but I think only recent versions support XML files.

Excel 2003
Access 2003

 

[Phil]

'support.microsoft.com/kb/285329'

Not allowed to post URL's

Regards

 

[Darth Vodka]

'support.microsoft.com/kb/285329'

Not allowed to post URL's

Regards

by jingo that looks like it

thanks mysterious Phil!

 

[Darth Vodka]

don't suppose anyone can point me in the right direction for creating a template from the attachment?

 

[Matt_B]

I was going to say Darth whenever I have tried to import/export XML with Excel you need to specify a DTD and after several long tiring attempts I am afraid to say I have never figured out a way to get it working even remotely.

 

[Phil]

CSV of attachment... No idea if this is correct as I have no knowledge of the original or required data!

 

[Macky]

Just who is the mysterious Phil?

Swooping in solving DV's Access woes, then disappearing again in the blink of an eye.
He's like an XML guardian angel, I'll bet not even Richard Dawkins could explain it.
It's enough to turn you theist.