Pulling in data from system ODBC

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.

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".

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.