Getting MS Access data into MySQL database

[Dragonsi]

Hi all,

I am trying to find out a quick way of transfering details from a membership database stored in MS Access into the MySQL database used for a phpBB2 forums.

I only need to transfer the follow:

Name
Email
Username
Password

The other information required by the forums can be entered by the members on first login. There are over 500 entries, so doing it one by one is not an option.

Any suggestions please? Also - what's the best way to view the MySQL database on a Windows system once downloaded from the server?

[ccpadmin]

i just did this myself for a project I am working on. I just exported to a text file(FILE->EXPORT), then select textfile and leave the options as is(DELIMITED) the only thing I would change is to seperate the fields by semicolon (;) so that when you import it to the table in MySQL it goes with no hiccups.

Oh one thing...You are using PHPmyAdmin, right?

If so then you will see a link at the bottom of one of the screens to import the data from a textfile to the table.

If not, download it now.