List:General Discussion« Previous MessageNext Message »
From:michael johnson Date:June 20 2002 6:25am
Subject:RE: How to convert an Access 2000 Database on PC to a MySQL on UnixPlatform
View as plain text  
We have a product that will convert the data and data types for you. See
www.bpenet.net/bpeaccess.htm

We can send you a trial version just email joy@stripped


Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)1323 438975
Fax +44(0)1323 738355
email michael@stripped
URL www.bpenet.net
Also in Dublin & Luxembourg

-----Original Message-----
From: Oliver Vecernik [mailto:vecernik@stripped]
Sent: 19 June 2002 19:50
To: Liqiang Feng
Cc: mysql@stripped
Subject: Re: How to convert an Access 2000 Database on PC to a MySQL on
UnixPlatform

Liqiang Feng schrieb:
> I need to convert an Access 2000 Database on PC to a MySQL database on
> Solaris platform. What is the best way to accomplish this? Any
> suggestions, pointers are appreciated.

You can accomplish this by using ODBC (3.51.03). Define a DNS to your
database. Within Access choose File->Export and ODBC() as type. After
completing the dialogs the table is created and data are transferred
automatically.

The only drawback is to choose each table seperately. If you need this
functionality more often, you can create a macro...


HTH,
Oliver


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread112513@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-michael.johnson=humphreyconsulting.co.uk@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
How to convert an Access 2000 Database on PC to a MySQL onUnix PlatformLiqiang Feng19 Jun
  • Re: How to convert an Access 2000 Database on PC to a MySQL on UnixPlatformOliver Vecernik19 Jun
    • RE: How to convert an Access 2000 Database on PC to a MySQL on UnixPlatformmichael johnson20 Jun
  • 3.23.51 LIMIT efficiency problemMark Hazen20 Jun
    • Re: 3.23.51 LIMIT efficiency problemDan Nelson20 Jun
    • Re: 3.23.51 LIMIT efficiency problemcentral20 Jun
    • Re: 3.23.51 LIMIT efficiency problemBenjamin Pflugmann20 Jun