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?
I have done this with great success.
Elizabeth Leonard
Clinical Systems Analyst
Clinical Affairs
New York University College of Dentistry
NY, NY 10010
Think outside the box.
-----Original Message-----
From: Michael Widenius [mailto:monty@stripped]
Sent: Wednesday, March 22, 2000 4:46 PM
To: myodbc@stripped; mysql@stripped
Subject: Converting Access tables to MySQL data on Unix
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
PS: I tried to search the email mailing archive before posting..
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread1366@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@stripped instead.
