title: Easiest way to continually import data to MySQL from a dbf file on my local computer
body: <p>I have a problem that has been annoying me for quite some time now and a few days ago I started googling for a solution, but I haven't really gotten anything to work. I've read a little about something called SSIS, but I'm not sure it does what I'm looking for or if there is something else I should research in order to accomplish my goal. This is my problem:</p>
  
  <p>My accounting program produces and updates a .dbf file with information about all vouchers and places it in a folder on my local computer. Our MySQL must continually be updated with this information. So this is what I do twice a day:</p>
  
  <ul>
  <li>I open up the .dbf file in excel</li>
  <li>Save it as a .csv.</li>
  <li>Close Excel</li>
  <li>Open the file in notepad++</li>
  <li>Convert the formating to utf8</li>
  <li>Save</li>
  <li>log in to MySQL</li>
  <li>Go to the right table</li>
  <li>Upload the .csv</li>
  <li>Replace the old data with the new</li>
  </ul>
  
  <p>As this takes quite a bit of time, I feel that there must be better ways to do this. It would be great if I could have this scheduled to be done automatically or if there is some kind of an SQL query that could do this, because then I could use PHP to make a website that I could enter and have the query run when I press a button or something.</p>
  
  <p>So my question is: What is the most simple way to continually get the info from the .dbf file into my SQL server?</p>