Simon Dobson wrote:
> 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.

The question remains - can you run your access database on Linux? AFAIK
you can't. You can get to it with ODBC from a Linux box, but the
database itself must run on a Windows box.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================