List:General Discussion« Previous MessageNext Message »
From:Steve Yates Date:December 4 2002 7:18pm
Subject:Re: access->mysql
View as plain text  
On Wed, 4 Dec 2002 14:39:01 -0000, Sandeep Murphy wrote:
>method for converting a huge database i hv in Access xp to MySQL  ??
>

	I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table.  Worked fine. 
I'm sure one could accomplish the same thing in Access natively but I'm
far better versed in Delphi.  One note...at least in Delphi, uploading
from the desktop is FAR faster using a query and update/insert than
using a table, especially since one can use multiple VALUES per INSERT
query.

 - Steve Yates
 - Line noise provided by Ameritech!

~ Taglines by Taglinator - www.srtware.com ~

Thread
access->mysqlSandeep Murphy4 Dec
  • Re: access->mysqlSteve Yates4 Dec
  • Re: access->mysqlCrercio O. Silva5 Dec
RE: access->mysqlSteve Bradwell4 Dec
RE: access->mysqlDavid Brodbeck4 Dec
RE: access->mysqlIan Zabel4 Dec
  • Re: access->mysqlCarlin Anderson5 Dec
RE: access->mysqlChris Couture5 Dec
RE: access->mysqlSandeep Murphy5 Dec
  • How is DBTools Software?Will Standley7 Dec
    • Re: How is DBTools Software?Michael She7 Dec
      • RE: How is DBTools Software?Chris Mason8 Dec
        • Re: How is DBTools Software?Insanely Great8 Dec
        • RE: How is DBTools Software?Michael She8 Dec
  • Compiling a list of MySQL tools - Please contribute.Will Standley8 Dec
    • Re: Compiling a list of MySQL tools - Please contribute.Paul DuBois8 Dec
  • Can u us a "source code" file to setup a db in MySQL ?TopMailBox9 Dec
    • Re: Can u us a "source code" file to setup a db in MySQL ?Gerald R. Jensen9 Dec
      • How to get MySQL to list current db's ?Will Standley10 Dec
        • Re: How to get MySQL to list current db's ?Sherwin T. Ang10 Dec
        • Re: How to get MySQL to list current db's ?Daniel Kiss10 Dec
        • Re: How to get MySQL to list current db's ?Michael She10 Dec
          • Where does MySQL store db files?tmb10 Dec
            • How to see # of rec's in all tablestmb10 Dec
              • Re: How to see # of rec's in all tablesBenjamin Pflugmann11 Dec
              • re: How to see # of rec's in all tablesVictoria Reznichenko11 Dec
            • Re: Where does MySQL store db files?Robert Citek10 Dec
              • Re: Where does MySQL store db files?Francisco10 Dec
            • RE: Where does MySQL store db files?Adolfo Bello10 Dec
        • RE: How to get MySQL to list current db's ?Brian P. Austin10 Dec
  • Re: access->mysqlGrant Cooper13 Dec