On Thu, 23 Mar 2000, Elizabeth Leonard wrote:
..
> why not just create a linked table between the MYSQL database and
> Access 97 through MYODBC, run an update query to copy all the Access
> 97 stuff into the MySQL table and forget Unix?
The trouble with this scheme is that if you have a lot of data to
transfer, it takes basically forever, and since the query is running on MS
Access (which is none too reliable) you have no way of knowing if things
are still going nicely or if MS Access just locked up..
> Hi!
>
> A MySQL customer just asked me if anyone has been able to directly
> access rows in a Access97 database file on Unix. If anyone has a
> solution or know a solution (even commercial) of this, please mail me
> about this.
..
A more useful tool (in Monty's case) is MDBTools
(mdbtools.sourceforge.net). It is not too pretty, and is still at a low
level of functionality.
However: it can do one important thing: read MDB files and export them as
CSV. At that point, you can use either Perl or even MySQL's READ DATA
INFILE to put the data into a MySQL (or any other RDBMS) table.
---------------------------------------------------------------------
Orlando Andico <orly@stripped> +63 (2) 937-2293
Mosaic Communications, Inc. +63 (917) 531-5893
Any sufficiently perverted technology is indistinguishable from Perl.
