title: How do I export a DataTable to new DBF file in vb.net?
body: <p>I have a DataTable that I've populated with a variety of data from other datatables, and the field names change often. My question is how would I export this DataTable to a DBF file? </p>
  
  <p>Here is what I've come up with but it simply doesn't know how to extract the data from the DataTable...</p>
  
  <pre><code>Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;” &amp; “Data Source=” &amp; path &amp; “;” &amp; “Extended Properties=dBase IV”)
  
          dBaseConnection.Open()
  
          Dim SQLCreateCommand As String
          SQLCreateCommand = "SELECT * INTO NewTable From " &amp; DataTable
          Dim dBaseCommand As New System.Data.OleDb.OleDbCommand(SQLCreateCommand, dBaseConnection)
  
          dBaseCommand.ExecuteNonQuery()
          dBaseConnection.Close()
  </code></pre>