MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Bryant Hester Date:November 26 2002 2:47pm
Subject:Re: Is it possible to export data from access to MySQL?
View as plain text  
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Steve,

It is quite possible. You can use MyODBC to connect your current
Access database(s) into your MySQL server directly, the major
drawback is that you'd have to create the overall table structure in
MySQL first and then link the table from MySQL into Access through
the File|External Data|Link Table... Menu. Or you can find and
download DBTools which will export your tables for you into MySQL. I
use MyODBC to connect some of my users to MySQL through Access, as
that was the easiest route for my end-users.

HTH,
Bryant H. Hester

- -----Original Message-----
From: Steve Jackson [mailto:stephen.jackson@stripped] 
Sent: Tuesday, November 26, 2002 8:38 AM
To: MySQL General Mailing list
Subject: Is it possible to export data from access to MySQL?


Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks to input and I've
convinced my boss to use MySQL rather than any other DB because of
it's compatibility with PHP. However I (probably hastily) *assumed*
that there would be a way to export the data. Any ideas?

Steve Jackson
Web Developer
Viola Systems Ltd.
http://www.violasystems.com
stephen.jackson@stripped
Mobile +358 50 343 5159

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPeOJiklWu7/HFp4nEQLL8gCdGyKJWMwrVjqnyUczHBQswrt2xIYAoMJH
H2FttK0BuepoUPFNby40uuGP
=Yty5
-----END PGP SIGNATURE-----

Thread
Is it possible to export data from access to MySQL?Steve Jackson26 Nov
  • Re: Is it possible to export data from access to MySQL?FlashGuy26 Nov
    • RE: Is it possible to export data from access to MySQL?Steve Jackson26 Nov
  • Re: Is it possible to export data from access to MySQL?Iikka Meriläinen26 Nov
  • RE: Is it possible to export data from access to MySQL?Jim Esten26 Nov
  • Re: Is it possible to export data from access to MySQL?Chris Knipe26 Nov
  • Re: Is it possible to export data from access to MySQL?John Ragan26 Nov
  • Re: Is it possible to export data from access to MySQL?Listen Hinz26 Nov
Re: Is it possible to export data from access to MySQL?Bryant Hester26 Nov
RE: Is it possible to export data from access to MySQL?Steve Bradwell26 Nov
Re: Is it possible to export data from access to MySQL?Ed Reed26 Nov
RE: Is it possible to export data from access to MySQL?Steve Bradwell26 Nov