>I'm using Doug Hennig's code to import large .dbf files into SQL Server 2008 and have discovered that all chr(13) are removed when importing with SQLXMLBulkLoad.
>
>Using:
>cursortoxml(alias(),lcData,1,512+8,0,lcSchema)
>
>I have verified that the XML file contains the CR+LF
>
>The memo fields are wrapped in CDATA in the XML file.
>
>Any ideas?
'Large' and 'XML' togwether doesn't sound right at all. I would use SqlBulkCopy class instead.
http://www.foxite.com/archives/0000207817.htmhttp://www.fox4um.com/topic/1214/sqlbulkcopy/Cetin