title: Access DB5 to MySQL automatically
body: <p>I have a problem, and was hoping I could rely on some of the experience here for advice and a push in the right direction. I have an MS Access file made by propietary software. I only want to take half the columns from this table, and import into new(not yet setup)mysql database.</p>
  
  <p>I have no idea how to do this or what the best way is. New data will be obtained each night, and again imported, as an automatic task.</p>
  
  <p>One of the columns in the access database is a url to a jpeg file, I want to download this file and import into the database as a BLOB type automatically.</p>
  
  <p>Is there a way to do this automatically? This will be on a windows machine, so perhaps it could be scripted with WSH?</p>