on 3/22/00 5:45 PM, Michael Widenius at monty@stripped 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
>
> 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.
>
You can indirectly. One of the perks of using chilisoft's asp for
linux/solaris is a full - blown sqllnk implementation.
The easy way:
This will allow you to ref a Access97/2000 db on an NT box via odbc. You can
then use an ASP page and import the tables via adodb script style to get
the deed done.
The harder way:
By SQLLNK separately and write a C program using standard ODBC calls to do
the transfer.
The BEST way:
Take 10 mins to write a VB application to transfer the data from the wintel
environment.
