I'm trying to convert an XML file to DBF. Right now I do this manually, opening the XML file in Excel 2003 and saving it as a DBF 4 file type. This is a boring and time consuming process, made worse by the fact that neither Office 2007, nor Office 2008 for Mac allow saving as DBF any more.
I'd like a way to automate this, if possible. Do you know any way of actually doing this? I don't even know what programming language to use for this...
Use a XmlReader, format your data and use OleDb to save to a dbf file. Here you can find a connectionstring for dbf: www.connectionstrings.com