title: MS Access Convert from Unicode when Reading from Text File
body: <p>So, I have an Access database where I import data from a text file.  The file is semi-colon delimited.  Occasionally (and will become more frequent) I receive a file from one of our affiliates from Russia.  The file has unicode (I think) characters like "Ìèðîøíèêîâ" instead of "Мирошников".  Ultimately, I'd like to translate those into English upon import, but for now, I'll accept the Russian characters.</p>
  
  <p>How should I go about doing this?  Currently, I'm reading each line of the file, using the SPLIT function to separate each field by the ";" separator into an array, and sticking each array element into a table.  Would changing the system Keyboard Layout to Russian prior to this work, or is it more complicated than that.</p>
  
  <p>Does any of this make sense, or should I just bag it and go grab a beer (or some Vodka)?</p>
  
  <p>Thanks!</p>