List:MySQL ODBC« Previous MessageNext Message »
From:James Lyon Date:March 23 2000 4:41am
Subject:Re: Converting Access tables to MySQL data on Unix
View as plain text  
> > 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.
>
>     [...snip...]
>
> The BEST way:
>
> Take 10 mins to write a VB application to transfer the data from the wintel
> environment.

Am part way through a little Delphi app. to do the job for Paradox tables ...
simple task to extend that to arbitrary databases using BDE native drivers
and/or ODBC as required. I'll contribute via TcX once I'm done, but it'll be
days away coz I'm buried under an e-Commerce nightmare project from hell at
present ;-)

Thanks,
James.

Thread
Converting Access tables to MySQL data on UnixMichael Widenius23 Mar
  • Re: Converting Access tables to MySQL data on UnixPeter Carter23 Mar
    • Re: Converting Access tables to MySQL data on UnixJames Lyon23 Mar
      • Re: Converting Access tables to MySQL data on UnixMichael Widenius23 Mar
    • Re: Converting Access tables to MySQL data on UnixJames Lyon23 Mar
  • RE: Converting Access tables to MySQL data on UnixElizabeth Leonard23 Mar
    • RE: Converting Access tables to MySQL data on UnixOrlando Andico23 Mar
  • Re: Converting Access tables to MySQL data on Unixsinisa23 Mar
Re: Converting Access tables to MySQL data on UnixEd Carp23 Mar
  • Re: Converting Access tables to MySQL data on UnixMichael Widenius23 Mar
    • RE: Converting Access tables to MySQL data on UnixElizabeth Leonard23 Mar
      • RE: Converting Access tables to MySQL data on UnixMichael Widenius24 Mar
Re: Converting Access tables to MySQL data on UnixJohn Calder23 Mar
  • Re: Converting Access tables to MySQL data on UnixAaron Johnson23 Mar
  • RE: Converting Access tables to MySQL data on UnixKevin J. Morgan23 Mar
Re: Converting Access tables to MySQL data on UnixDerek M Wickersham23 Mar
Re: Converting Access tables to MySQL data on UnixRuben I Safir23 Mar
Re: Converting Access tables to MySQL data on UnixDerek M Wickersham23 Mar
RE: Converting Access tables to MySQL data on UnixJohn Calder24 Mar
  • RE: Converting Access tables to MySQL data on UnixSteve Lawrence24 Mar