Sunday, May 6, 2012

Convert DBF to XML

Free DBF Viewer
+ can also be used to open XML file and export it to DBF
(DBF to XML) If you need to alter/customize the tag-names in the resulting xml, follow these steps:
a. Open dbf
b. Display SQL Panel (View\SQL Panel)
c. Type SQL command: select [original_caption] as [new_caption], .... from [dbf_name]
d. Click "Run SQL Select statement" (thunderbolt button)
e. export as usual

Use CursorToXML function
Sample commands:

CURSORtoxml("kursor","C:\vfpfunc1.XML",1,512)
CURSORtoxml("kursor","C:\vfpfunc2.XML",2,512)
CURSORtoxml("kursor","C:\vfpfunc3.XML",3,512)
** 1/2/3 determine xml type generated   512 means write to file
XMLTOCURSOR("C:\test.XML","sectrs1",512)
** 512 means read from file






No comments:

Post a Comment