xml to foxpro table

[junkmail]

What is the quickest way to take an xml file and create a free visual FoxPro table in vb.net?

 

[SBTBILL]

You need to turn the file into a csv or text file. I'd consider loading it into EXCEL and saving that as a csv.

 

[SBTBILL]

I rarely see XML files. A sample might help.

 

[junkmail]

Is there an easy way to take the dataset and write it out to a foxpro table?

 

[jebenson]

You should be able to. Here's a connection string I use to read from a FoxPro database:

ConnStr = "Provider=vfpoledb;Data Source=Path\to\database\container.dbc;Mode=ReadWrite|Share Deny None;Collating Sequence=MACHINE;Password=''"

You can get the VFP OleDB driver at this link:

http://www.microsoft.com/en-us/download/details.aspx?id=14839

With this, you should be able to write you data to the FoxPro tables, using the usual methods (e.g., OleDbConnection, OleDbDataAdapter, DataSet/DataTable, OleDbCommand, etc.)



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[junkmail]

Thanks all.