MS Access ----> MySQL ?

[Richard Kimberley]

Hi there :)

Does anyone know of a way, if I have a MS Access database table, how I can
transfer all the data over to a MySQL database?

Any ideas at all of how to do this? Or if not Access, them maybe Excel..?

Cheers,

Rich.

[Paul Law]

Hi Rich,

> Does anyone know of a way, if I have a MS Access database table, how I can
> transfer all the data over to a MySQL database?

You need MyODBC which you can download from http://www.mysql.com.

There are certainly more knowledgable people here who can explain it better,
but when I was trying to figure this out last week I found that the
documentation for MyODBC was not great, so here's how I did it, hopefully it
will work for you. Unfortunately you need to do some configuring first, but
once it is done it seems to run fine.

1) Unzip the MyODBC archive to any folder , I called mine MyODBC
2) Go to this folder and find the setup application and run it.
3) Choose MySQL from the list of ODBC drivers (This should be the only one
available).
4) Click on OK.
5) You will probably get another dialog called Data Source, you can cancel
this by clicking on close.
6) Go to Control Panel and find something that looks like "DataSource
(ODBC)". I am using Win2000 and I found this in Admin Tools. Once you have
found this run it.
7) Select System DSN from the tabs and click on ADD and scroll down the
available list of drivers until you find MySQL. Selec this and click on
Finsh.
8) Select a Data Source Name (DSN) such as "MySQL database" or whatever you
want.
9) Add the details of your MySQL server, such as host name, user name and
password. Be sure to include the port of 3306. (It took me ages to work this
out)
10) Click OK.

Thats it, you are ready to roll. Goto to MS Access and select export. From
the dialog of database types select ODBC (usually at the bottom). You will
then need to select the DSN you have set up, ie MySQL Database and you are
away, it should tranfer all of the data. You can also do the same in reverse
to import data from MySQL to Access.

I hope this helps, give me a shout if you get stuck

Paul

[Günter Ladwig]

Hi!

> Does anyone know of a way, if I have a MS Access database table, how I can
> transfer all the data over to a MySQL database?
>
> Any ideas at all of how to do this? Or if not Access, them maybe Excel..?

http://www.cynergi.net/exportsql/ contains a script that should be able to
transfer a Access database to MySQL. I never tried it, though. Another
possibility is to export your database as a .csv file and then use "LOAD
DATA..." to insert the data into your database.

ciao

guenter
----
Günter Ladwig - gla...@iname.com - ICQ# 14360158

[T.A. Nyquist]

"Richard Kimberley" <richardk...@ntlworld.com> skrev i melding
news:lhha6.3729$vH6....@news6-win.server.ntlworld.com...

With Excel you could export a tab-delimited page and import that into
MySQL with help of PHP.

--

Greets
T.A. Nyquist
Software engineer
Eutax DA
tany...@eutax.no
www.eutax.no

[mhar...@my-deja.com]

In article <lhha6.3729$vH6.75076@news6-
win.server.ntlworld.com>,
"Richard Kimberley"

We are releasing an Access to MySQL Converter
very soon. It is written in PHP4 and
offers a direct conversion. No interim ASCII or
other files. If interested. Let me know.

mhar...@vacnet.com

Sent via Deja.com
http://www.deja.com/