title: Using download.file to download a zip file from URL in R
body: <p>I am trying to use download.file to extract a zip file from a URL and then push all the data in each of the files into a MySQL database.  I am getting stuck in the first step where I use download.file to extract the zip file</p>
  
  <p>I have tried the following but to no avail</p>
  
  <pre><code>myURL = paste("https://onedrive.live.com/download.aspx?cid=D700ACC18C0F37E6&amp;resid=D700ACC18C0F37E6%2118670&amp;ithint=%2Ezip",sep = "")
  download.file(url=myURL,destfile=zippedFile, method='auto')
  
  myURL = paste("https://onedrive.live.com/download.aspx?cid=D700ACC18C0F37E6&amp;resid=D700ACC18C0F37E6%2118670&amp;ithint=%2Ezip",sep = "")
  download.file(url=myURL,destfile=zippedFile, method='curl')
  </code></pre>
  
  <p>Please suggest where am I going wrong.  Also some pointers on how to take one file at a time from the zip folder and push into a DB will be most helpful</p>