命令如下：
XML 原文件(1.xml)
<?xml version="1.0" encoding="GBK" standalone="true"?>
<row>
<akc190>00001907176607399</akc190>
<aka130>0201</aka130>
<aac001>320016387</aac001>
<aae011>杨清江</aae011>
<aae036>2019-07-17 16:06:10</aae036>
<yka103>00001907177491373</yka103>
</row>
当我用  XMLTOCURSOR("d:\1.xml","curTest",512)  时
转出来的表 akc190 aka130 yka103 都全转为数值型，前面的0都没有了，有办法保持0转为字符型字段吗？

谢谢你的好方法，解决了！对了你说的 自己创建一个 XSD 文件,定义好字段格式，再导入 ！这个要怎么操作呢？

谢谢，主要是有的接口还是用XML，Jason的你也有吗？可以分享下吗？ 比如下面的Jason,要取到 bName
{"clientId":"200_1","code":"0","data":"{\"items\":[{\"bName\":\"左氧氟沙星\",\"bagUnit\":\"盒\",\"cmqc\":\"\",\"costPrice\":0.0000,\"dosageForm\":\"\",\"dose\":\"0.0\",\"doseUnit\":\"\",\"eName\":\"\",\"id\":\"11185\",\"isSell\":\"1\",\"itemType\":\"16\",\"manufacturer\":\"\",\"name\":\"\",\"pingyin\":\"zyfsx\",\"prescriptionNumber\":\"10\",\"prescriptionUnit\":\"支\",\"retailPrice\":0.0300,\"sellPrice\":\"0.0100\",\"spec\":\"\",\"status\":\"1\",\"statusText\":\"启用\"},{\"bName\":\"丹参川芎嗪注射液\",\"bagUnit\":\"支\",\"cmqc\":\"H22026448\",\"costPrice\":0.0000,\"dosageForm\":\"28\",\"dose\":\"5.0\",\"doseUnit\":\"\",\"eName\":\"\",\"id\":\"11186\",\"isSell\":\"2\",\"itemType\":\"16\",\"manufacturer\":\"吉林四长制药有限公司\",\"name\":\"\",\"pingyin\":\"dccxqzsy\",\"prescriptionNumber\":\"1\",\"prescriptionUnit\":\"支\",\"retailPrice\":0.0200,\"sellPrice\":\"0.0000\",\"spec\":\"5ml\",\"status\":\"1\",\"statusText\":\"启用\"},{\"bName\":\"独活寄生丸\",\"bagUnit\":\"g\",\"cmqc\":\"\",\"costPrice\":0.0000,\"dosageForm\":\"\",\"dose\":\"0.0\",\"doseUnit\":\"7\",\"eName\":\"\",\"id\":\"11187\",\"isSell\":\"0\",\"itemType\":\"16\",\"manufacturer\":\"\",\"name\":\"\",\"pingyin\":\"dhjsw\",\"prescriptionNumber\":\"0\",\"prescriptionUnit\":\"\",\"retailPrice\":5.0000,\"sellPrice\":\"0.0000\",\"spec\":\"\",\"status\":\"1\",\"statusText\":\"启用\"}],\"pageEnable\":1,\"pageIndex\":1,\"pageSize\":1000,\"totalPage\":1,\"totalSize\":3}","key":"326617741564139847037","msg":"成功","timer":1564139847037,"type":"110","versionType":"3"}

[此贴子已经被作者于2019-7-26 11:18编辑过]

谢谢，先实验下看！