List:MySQL ODBC« Previous MessageNext Message »
From:James Lyon Date:March 23 2000 2:27pm
Subject:Re: Converting Access tables to MySQL data on Unix
View as plain text  
> >> 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!

It's v. rough-and-ready at present ... missing such things as automatically guarding
against tables with reserved names and other things besides! Still, It has managed to
(with a tweak or two) get my Pdox database tables created and populated in MySQL simply
enough. I have to get on with the project I wrote it for now, but I'll come back and tie
up the loose ends next week then I can send it on up the line :)

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