Hello
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.
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.
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.
Is there a way to do this automatically? This will be on a windows machine, so perhaps it could be scripted with WSH?