Convert MS Access database to MySQL

[Guest]

Is there any free software that will convert MS Access database to a MySQL database? Is this possible?

Thank you,
AdonaiEchad

[MarkG75]

I use a piece of software called MyAccess

http://www.hiden.org/myaccess/

[Newsgroup_User]

AdonaiEchad wrote:
> Is there any free software that will convert MS Access database to a MySQL database? Is this possible?

If you do a Google search for "convert access to mysql", you'll come up
with a lot of options. The method that I use requires no software other
than Access and MySQL. Export the Access database as a CSV file. Then
use LOAD DATA INFILE to import it to MySQL:

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

If you use phpMyAdmin, it automates the whole process. Just select the
Import tab and select the appropriate options for importing a CSV file.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

[Guest]

What are the steps to convert access database as a CSV file. I have access 2003.


AdonaiEchad

[Newsgroup_User]

Look under Access' FILE | Save As options?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================


"AdonaiEchad" <webforumsuser@macromedia.com> wrote in message
news:eh0283$1cr$1@forums.macromedia.com...
> What are the steps to convert access database as a CSV file. I have
> access 2003.
>
>
> AdonaiEchad

[Newsgroup_User]

AdonaiEchad wrote:
> What are the steps to convert access database as a CSV file. I have access 2003.

I don't have Access installed on this machine, so I can't check, but
it's either what Murray suggests or File > Export.

Why not try the Access Help menu?

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

It's FILE | Export > CSV....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================


"David Powers" <david@example.com> wrote in message
news:eh04gs$3v9$1@forums.macromedia.com...
> AdonaiEchad wrote:
>> What are the steps to convert access database as a CSV file. I have
>> access 2003.
>
> I don't have Access installed on this machine, so I can't check, but it's
> either what Murray suggests or File > Export.
>
> Why not try the Access Help menu?
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

[Newsgroup_User]

AdonaiEchad escreveu:
> Is there any free software that will convert MS Access database to a MySQL database? Is this possible?
>
> Thank you,
> AdonaiEchad
------
DBManager

http://www.dbtools.com.br/EN/downloads/
-----
zerof