title: Ruby win32ole MS Access: How to find all the records updated since last export?
body: <p>I am using win32ole module/library to gain access to an Access database. But I can't find as I can in Rails the created_at or updated_at columns in any of the tables in the database. I was wondering how does one finds rows that are updated, then?</p>
  
  <p>So I have</p>
  
  <pre><code>require 'win32ole'
  connection = WIN32OLE.new('ADODB.Conneciton')
  conneciton.Open('Provider = Microsoft.ACE.OlEDB.12.0; Data Source = c:\data.accdb')
  
  recordset = WIN32OLE.new('ADODB.Recordset')
  recordset.Open(some_sql, connection)
  
  fields = []
  recordset.Fields.each do |field|
   fields &lt;&lt; field.name
  end
  
  data = recordset.GetRows.transpose
  
  so data = [
  ['john', 'doe', 'author'],
  ['mick', 'jagger', 'singer'],
  ['woody', 'allen', 'direct'],
  ['pablo', 'picasso', 'painter'],
  ['homer', 'simpson', 'loser']
  ]
  
  fields= ['first', 'last', 'occupation']
  </code></pre>
  
  <p>But if someone changed Homer's job to 'Winner', what kind of SQL query do I use to find out about this. Presumably, there's a last-checked timestamp to make sense of this. Let's just say it's provided, how does one go about it then?</p>