You've to specify additional flag (IIRC 8192) if you want XMLTOCURSOR() to use existing cursor.
It would be more helpful if you attached a ZIP file with sample XML.

>
>
>Thanks, that worked great. I formatted my XML correctly and now I'm trying to get it into my cursor. The problem is that all the columns I selected (statement # 7) when creating the cursor disappeared and the cursor now contains an empty "Detail" column. I use the 512 on parameter after trying all the other parameter in the XMLTOCURSOR statement. Here is my code:
>
>

>1  cPreTag = '<?xml version = "1.0"?><Report>'
>2  cPostTag = "</Report>"
>3  cTagName = STREXTRACT(FILETOSTR("C:\test2\PayRegExtract.xml"),"<Table1>","</Table1>",1,1)
>4  cPassTag = cPreTag+cTagName+cPostTag
>5  MESSAGEBOX(cPassTag,0,'')
>6  STRTOFILE(cPassTag,"C:\test2\convert.xml",0)
>7  SELECT * from xfer_payroll INTO CURSOR crsparse readwrite
>8  XMLTOCURSOR("C:\test2\convert.xml","crsparse",512)
>

>
>The XML looks as follows:
>
>

><?xml version = "1.0"?><Report><Detail_Collection><Detail PP="2009-14" NAME="ABBATOYE ........
>

>
>I have also attach a sample of xml layout and the cursor before and after the import. Do you guys see anything wrong with my xml format that prevents me from bring it back into a cursor?
>
>Thank
>nick