xml and truncating

[dbprogman]

HI ALL

We currently are looking at importing xml files into our access database, there are three (3) files in all two (2) import perfectly however one (1) has problems. The problem is that one field name is greater than 64 characters. Is there a way we can either truncate this on import or exclude it on import.

Thanx 4 ur help...

 

[reclusivemonkey]

You can tranform your XML file using an XSLT stylesheet to process the original XML, just changing the problem node's name to something less than 64 characters.

 

[dbprogman]

Re: Xml

Thanks for your reply, would you know where to locate info for using XSLT?

 

[reclusivemonkey]

I find www.topxml.com and www.w3schools.com/xsl to be very helpful when starting out. There are a few examples on topxml on converting XML with XSL that should be enough to get you going.

 

[dbprogman]

Xml

Thanks for all your help very much appreciated.

 

[reclusivemonkey]

No problem, glad I could be of help.