List:MySQL ODBC« Previous MessageNext Message »
From:Michael Widenius Date:March 23 2000 2:37pm
Subject:Re: Converting Access tables to MySQL data on Unix
View as plain text  
Hi!

>>>>> "James" == James Lyon <james.lyon@stripped> writes:

>> > 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.

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

James> Thanks,
James> James.

Thanks for the reply and we are waiting to put your tool in the
Contrib directory for others to enjoy!

Regards,
Monty
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