Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to transform dbf file to xml 1

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Anyone knows how to transform dbf file format to xml format?
Any comments would be appreciated.

ant~~
 
ant,

It depends what database you want to format. For example SQL Server 2000 has some standard procedures for exporting and importing XML data. Most "Old" databases doesn't have standard functionality so you will have to write some conversion functions yourself. I think DBase doesn't support it yet.

Good luck.
 
See:
HOWTO: Convert FoxPro Cursor into XML Data Format

Alternatively, you can use ADO to connect to the dbf thru ODBC, query the entire dbf into a recordset, and use the recordset's save method to create an XML file. Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top