View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 09:24 AM
Michael Vilain
 
Posts: n/a
Default Re: Open source tool for converting Microsoft Access (MDB) to MySQL

In article <55uf5tF26k8iqU2@mid.individual.net>,
Simon Dobson <replytogroup@nospam.domain.invalid> wrote:

> Hello all,
>
> I've a large MDB file created by a bespoke application. I'd like to run
> a cron job to pull the data from this and put it in a MySQL database
> through the night.
>
> Are there any open source tools that'll achieve this or get me close?


Off the top of my head, you could install perl and ODBC drivers for
Access. Will Access run on anything other than a Windows box? If so,
how were you going to "run a cron job" on a Windows box to pull the data
out of Access?

I'm sure there are open source job scheduling tools, maybe even a crond
that runs on XP. Just curious as you seem to be mixing environments.
In any case, there is a perl that runs on XP. You may also need a
compiler and development environment to build the database components,
however.

--
DeeDee, don't press that button! DeeDee! NO! Dee...



Reply With Quote