Lots of work has been done reading and writing to excel. Here are the links that were used to figure it out various parts.
To make things easy when possible, uploading and downloading csv files with an Excel header.
I wish I had the code from another project – but back to Google to re-figure it all out again – this is the old style Excel, not the new .xlsx xml version so using the Excel api is important to (re)understand
Downloading a generic file
Uploading a file
Manipulating the contents into an sql insert statement
- This gave me the most help. it is not like VBA
- odbc driver for mysql – version 3.51.30 – not version 5.0 for my purposes