title: Export MS Access Memo field and convert Unicode
body: <p>I have an Access 2003 database.  A table has a Memo field and I'm having issues with getting that data out.</p>
  
  <ul>
  <li>Exporting that field to a txt or csv chops that field off (255 characters)</li>
  <li>Exporting as Excel gives me strange characters for linebreaks</li>
  <li>Appending to a mysql database via myODBC gives an error about "incorrect string"</li>
  <li>Using VBA with Scripting.FileSystemObject doesn't work unless you tell it to create the file as Unicode, which is okay, but then I can't get the file converted to something I can import</li>
  </ul>
  
  <p>There are Unicode characters in some of my data.  It's not a multi-linual database, so the only ones I can find are slanted quotes, probably copied in from Word.  Dropping them is fine; the information in the fields will still be understandable.</p>
  
  <p>Can I convert these Unicode characters to their (ANSI? ASCII?) equivalents?  I've not dealt with encodings very much. </p>
  
  <p>I tried playing around with iconv, but without knowing anything about the encoding, it didn't really help.</p>
  
  <p>Right now, I need help on: 
   - converting the characters in my database so they export non-unicode-ish-ly
   - OR, converting the unicode characters after the file has been exporting.</p>