CONVERSION FROM DBF TO XML

  • Thread starter Thread starter sreejith s
  • Start date Start date
S

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
 
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.
 
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.
 
Back
Top