Rusty Robot wrote:
> 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.
>
yes, it can! look up sqlyog!

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".