The Access97 file format is very complex and copying it first then
analysing it is a tough call. I suggest 2 better ways.
1.
Install MyODBC on the machine which has Access97.
Set up a DSN pointing to the MySQL machine.
Then use Access97 export facility to export tables directly
to MySQL. This is quite easy, but it does require a
machine with Access97 to be on the same network as the
MySQL machine.
2.
Use the Access97-export-to-text facility,
then copy the results to MySQL-on-Unix and use
LOAD DATA INFILE.
This has the disadvantage that you need to
first build the table structure in MySQL to load into, but if this
is a repeated data load then it may work well for you.
(1) is by far the best solution as the table structure will
build on MySQL and the total job is done very simply with
very few steps.
At 00:45 23/03/00 +0200, you wrote:
>
>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.
>
>The idea is to, from time to time, copy Access97 datafiles to an Unix
>server and there extract the rows from them and put them into a MySQL
>database.
>
>Regards,
>Monty
>
