title: How to compare data file with column in SQL server database?
body: <p>I am required to compare data in a file with a column in SQL server database. I have been asked to use Microsoft Access to do the same. </p>
  
  <p>Additional information:
  File consists of many lines of text. Amongst the text is the a word that matches the column name of SQL server database. </p>
  
  <p>How should go about doing the comparison? If I use MS Access then I would write queries to extract information from SQL server but I don't know how to use (I am not sure if it possible) MS Access to compare information from file with information in database. </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>File structure:</p>
  
  <pre><code>    ABCDE       12324            ABCDE    ABCDE
      ABCDE       WORDSWORDSWORDS WORDS
      VERSION     NUMBER1.1   IDENTIFIER:129090
      WORDS WORDS WORDS
      WORDS WORDS
      ABCDE       22324            ABCDE    ABCDE
      ABCDE       WORDSWORDSWORDS WORDS
      VERSION NUMBER2.1 IDENTIFIER:129090
      WORDS WORDS WORDS
      WORDS WORDS
      ABCDE       32324            ABCDE    ABCDE
      ABCDE       WORDSWORDSWORDS WORDS
      VERSION XUMBER1.1 IDENTIFIER:129090
      WORDS WORDS WORDS
      WORDS WORDS
  </code></pre>
  
  <p>Database structure:</p>
  
  <pre><code>Column1 Column2 Column3 Accession_Ver Column4
  
  234     value2  value3  NUMBER1.1         value4
  456     value5  value6  NUMBER2.1         value7
  </code></pre>
  
  <p>I have to compare the value after word 'Version' (i.e NUMBER1.1) in data file with value in column name 'Accession_Ver' (i.e NUMBER1.1) in database. After comparison, if values are different then store them otherwise move on with comparison.</p>
  
  <p>I can use Perl to parse the data file but I am not sure how will I use MS Access to connect the file and database to compare information. </p>