Actually, it's not all that difficult to transfer data from Access to mySQL.
Once you've exported your Access data to a delimited text file, here's some sample code that I just used today:
<?php
include "php_lib/dbfunctions.php";
#include "../php_lib/header.php";
?>
<?php
$filename = "data2.txt";
$separator = ",";
if(!($myFile = fopen($filename, "r")))
{
print("could not open file");
exit;
}
$nmbrID = 3;
while(!feof($myFile))
{
set_time_limit(10);
$nmbrID = $nmbrID +1;
$myLine = fgetss($myFile, 255);
$member = explode($separator,$myLine);
for($i=0;$i<count($member);$i++)
{
$member[$i] = trim($member[$i]);
$member[$i] = str_replace(chr(34),"",$member[$i]);
}
$user_id = $nmbrID;
$username = $member[0];
$user_password = md5($member[1]);
$user_email = $member[2];
$user_style = 1;
$user_lang = "english";
$user_viewemail = 0;
$user_attachsig = 0;
$user_timezone = 8.00;
$query = "INSERT INTO phpbb_users (user_id, username, user_password, user_email, user_style, user_lang, user_viewemail, user_attachsig, user_timezone)
VALUES ($user_id,'$username','$user_password','$user_email',$user_style,'$user_lang',$user_viewemail,$user_attachsig,$user_timezone)";
$result = safe_query($query);
}
fclose($myFile);
?>
