On this page there is some information. Here's a quote:

Thanks skyhawk. You replied while I was editing my original post. I will give some of these tools a try. As I mentioned, I was tryiing Access to MySQL but not having much luck.
I have already tried a few other approaches. I tried doing it through the windows command line. I would use an access export and/or a text export but it seems you have to do it table by table. There are about 15 tables so I hoped there was a faster away.
I tried the ODBC technique as well but this did not work either.
However with your tips maybe I can get this working.

Thanks,
A.

This post has been edited by alien: 30 Nov, 2007 - 11:20 AM

The other thing you might do if there are no easy tools for Access is download MSDE (MSSQL Developer Edition) and import in to it from Access, then from MSDE out to MySQL.

Will SQL Server 2005 Express perform the same function as MSSQL Developer Edition?

A

I found the simplest way to transfer an Access DB over to the MySQL format. Simply download a program called 'Access to MySQL'. It is freeware.
Then use the wizard. Unfortunately, this wizard was not too magical because it just would not transfer the Access DB into mySQL. BUT the error message conveniently listed the commands it was trying to enter into MySQL in order to create the DB. So it was simply a matter of copying the list, removing extraneous messages, and then pasting it into MySQL.

If anyone else is having this problem my solution is the easiest one you can find I think. Although it is a bit slapshod, it works.

Thanks though for all your tips Skyhawk.

A.

The simplest and most convenient way to transfer Access/Excel data into an online mysql format is to use a program called Navicat. It is not free unfortunately but it is invaluable and makes data transfer easy and quick. It also has useful facilites for querying and working on the remote database and individual tables. I think there is a 30 day free trial too: _navicat.com/

Thanks for the suggestion. I looked at that program but opted out since it is not free. I figured for this basic task I did not need it, but in future I may look into it as my DB projects become more complex.
Speaking of querying and working on remote DBs, I know how to create a MySQL DB from scratch, and run various queries with it, but the class I took never covered remote administration, enabling various users access to the DB or even specific problems like creating non-text based password fields with unique encryption algorithms to use with PHP (for example).
Right now I notice the end-user password field in my DB is in a VARCHAR (20) format but the web designer I'm working with needs it to be in a 32 bit binary password format. I did some research and found that his needs can be accomadated with the MD5 algorithm but I'm not quite sure how to implement it. Have you done this before?

Regards,

A.

You need to have a user input form which receives the password, then encrypts it and submits it into the database. You also need to have a decryption algorithm which retrieves and decrypts the password then displays it in a browser (or runs some other function once it has been validated).

You can find more about MD5 and php here: _http://uk2.php.net/md5