title: SQL server table to FoxPro table issues
body: <p>I am trying to get some SQL server tables into FoxPro dbf.  </p>
  
  <p>I successfully managed to bcp export data such that when I use FoxPro Import Wizard, the data imports correctly.  But when I try to do it at the command line, I can at best import the first few columns and all the other columns disappear.  </p>
  
  <p>In the following directory, I put both the .CSV file and the successful DBF import table. </p>
  
  <p><a href="http://witold.org/se/" rel="nofollow">directory with 2 files here</a></p>
  
  <p>What I need to figure out is how to import these CSV files from the command line in FoxPro.   </p>
  
  <p>I tried various combinations of;</p>
  
  <pre><code>APPEND FROM D:\work\oh\output\sqloutput.csv TYPE CSV
  APPEND FROM D:\work\oh\output\sqloutput.csv DELIMITED WITH TAB
  </code></pre>
  
  <p>None of it works.  </p>
  
  <p>Any ideas? I know I have done this before, I don't remember what the trick was... </p>