WHAT I NEED: Help with determining the best 'light weight' way to
pull data into my mySQL database from an external ODBC data source.

MY SITUATION: I have a server that allows very restricted ODBC access
to its databases through a license restricted driver. For years I
have been using M$ Access to pull the data I need out of that server
over to my file server and into an ACCESS database, daily. I run
reports and application against the access databases. Now the size
restrictions of access, among other things, are getting in my way and
I would like to move to MySQL.

THE PROBLEM: I am a beginner with MySQL. I was hoping that I could
somehow use the mySQL command line client to pull data from an ODBC
connection into my SQL server but that doesn't seem possible. My
hardware is rather old so I'm looking for a 'light weight' method of
creating and updating tables on my mySQL server based on queries run
again ODBC database tables.

Can this be done without the aid of an expensive database manipulation
app like ACCESS?

Thanks for your help.