title: Import data in R from Access
body: <p>I'm trying to import a table from Microsoft Access (.accdb) to R.</p>
  
  <p>The code that I use is: </p>
  
  <pre><code>library(RODBC)
  
  testdb &lt;- file.path("modelEAU Database V.2.accdb")
  
  channel &lt;- odbcConnectAccess2007(testdb)
  
  WQ_data &lt;- sqlFetch(channel, "WaterQuality")
  </code></pre>
  
  <p>It seems that it works but the problem is importing date and time data. Into the Access file there are two columns, one with date field (dd/mm/yyyy) and another one with time field (hh:mm:ss) and when I import them in R, in date column appears the date with yyyy-mm-dd format and into the time column the format is 1899-12-30 hh:mm:ss. Also, R can't recognise these formats as a variable and I can't work with them.</p>
  
  <p>Also, I tried the mdb.get function but it didn't work as well.</p>
  
  <p>Does somebody know how to import the data in R from Access defining the date and time format   ? Any idea how to import the Access file as a text file?</p>
  
  <p>Note: I'm working with with Office 2010 and R version 2.14.1</p>
  
  <p>Thanks a lot in advanced.</p>