TEXT TO lcXml NOSHOW <?xml version="1.0"?> <cityList> <city cityCode="CITY1" cityDescription="CITY1 DESC"/> <city cityCode="CITY2" cityDescription="CITY2 DESC"/> <city cityCode="CITY3" cityDescription="CITY3 DESC"/> <city cityCode="CITY4" cityDescription="CITY4 DESC"/> </cityList> ENDTEXT = XMLTOCURSOR(lcXml, "crsXml")>I currently receive xml data from a web service, as follows:
><?xml version="1.0"?> > <serviceResponse returnCode="OK"> > <cityList> > <city cityCode="CITY1" cityDescription="CITY1 DESC"/> > <city cityCode="CITY2" cityDescription="CITY2 DESC"/> > <city cityCode="CITY3" cityDescription="CITY3 DESC"/> > <city cityCode="CITY4" cityDescription="CITY4 DESC"/> > </cityList> > </serviceResponse>>Anyway to rapidly enter this data into my table ( 2 fields, citycode and citydesc respectively )?