I'm a little mind struck at the second as I am looking to automate the following sequence:

1. Extract Data from Microsoft Access
2. Save files as CSV
3. Connect toMySQL server
4. Run one SQL file that exports all the CSV's using LOAD DATA LOCAL INFILE

I've written the entire SQL file that DROPs each table then re-uploads it and this runs like a dream in MySQL WorkBench. I just don't know how to get this to do the task without me physically carrying out the task...

**I am now stumped how to automate part 4...** There's no visual basic style backend to MySQL WorkBench and I thought requesting SSH from my provider would fix this, turns out my provider states SSH access is for web files not databases.

Is this the case with all MySQL or do some providers allow SSH directly to the database? If not how do I go about automating this sequence?

Many thanks.