<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>

This is a bash script
linux
example using
mdbtools
for automatic extraction and import from a mdb file to mysql.
```
```
#!/bin/bash

MDBFILE="Data.mdb"

OPTIONS="-H -D %y-%m-%d"
mdb-export $OPTIONS $MDBFILE  TableName_1 >  output_1.txt
mdb-export $OPTIONS $MDBFILE  TableName_2 >  output_2.txt

mdb-export $OPTIONS $MDBFILE  TableName_n >  output_n.txt

MYSQLOPTIONS=' --fields-optionally-enclosed-by=" --fields-terminated-by=, -r '
mysqlimport $MYSQLOPTIONS -L -uuser -ppasword database output_1.txt
mysqlimport $MYSQLOPTIONS -L -uuser -ppasword database output_2.txt
mysqlimport $MYSQLOPTIONS -L -uuser -ppasword database output_n.txt
```
```
You can use some others mysqlimport options: 
--delete: to delete previous Data from the target mysql table. 
--ignore: ignore duplicates
--replace: replace if a duplicate is found
It's not a windows solution but i Hope it helps.