Michael Vilain wrote:
>>
>> 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?

It was planned to FTP the file to the Linux server at 1am. I wanted cron
to run shortly after to get the data out of that.

> I'm sure there are open source job scheduling tools, maybe even a crond
> that runs on XP.

There's scheduled tasks (AT) for that :-)

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

The best solution for us would be getting the MDB file onto the Linux
box then having Linux put the data into MySQL tables. The servers aren't
on the same LAN so opening the ODBC can of worms is something I'd want
to avoid if at all possible.