CONVERSION FROM DBF TO XML

[sreejith s]

Hi to all,
Will any one help me with some coding to convert my DBF file to XML file
automatically,in every 3 hrs?

Thanks in advance
jith

 

[Nicholas Paldino [.NET/C# MVP]]

Jith,

Are you using SQL Server? If not, why not tell SQL Server agent to run
your task every three hours and then execute the appropriate statements
using the FOR XML statement?

Or, if that doesn't work, just create a console app which will do what
you want (you can use the FOR XML statement to help in SQL Server, or just
use the classes in the System.Xml namespace, along with the classes in the
System.Data namespace to get your data) and then set it up as a scheduled
task set to run every three hours.

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You would have to read the dbf files (I assume they are foxpro files) into a
dataset and then use DataSet.WriteXml to create a XML file.