Converting MS Access to mySQL

[Ardi]

Hi there,

I have created a database using Microsoft Access 2000 and I would like to convert it into a mySQL database. I have searched many places but they seem to be very vague. Can somebody please tell me in black + white how to convert?

Very much appreciated!!!

[Hierophant]

Create identical tables in MySQL.
Export your data from Access as Comma Separated Values (*.CSV).
Import the resulting text files into MySQL

[freddydoesphp]

Or go to http://www.mysql.com and go to the win32 downloads section and download MyAccess a freeware program that creates a MySQL database from a MS Access one for you, even does the tables

[Ardi]

Ok, thanks but I don't have MySQL installed on my computer, but it is on my web server.. these methods apparantly need MySQL to be installed on my own computer.

Any other suggestions?

[freddydoesphp]

Can youconnect to your database from a remote computer, Do you have access to the 'mysql' database here you could change how one can connect to the database then you could connect from a remote computer

[Ardi]

Yes I can connect remotely using the phpMyAdmin 2.0.1 script which is located on the web server control panel

[freddydoesphp]

Yes but that means that your script is running on the same computer as your database. You need to be able to connect with a script running on another computer.

[Ardi]

I mean the php script is located on the remote server.
Actually, I have figured the whole thing out now =)
Thanks for your time!!