On May 18, 9:20 am, lark <ham...@sbcdeglobalspam.net> wrote:
> 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 -- ham...@sbcdeglobalspam.net
> To reply to me directly, delete "despam".

Interesting. Downloading now. Thanks allot, I post back with my
results.