将mysql数据导入access数据库：

mysql数据库表sqltable 字段id，name，sex，email

access数据库表accesstable id，name，sex，email

<? $connect = mysql_connect("localhost","",""); mysql_select_db("mydatabase"); $sql = "select * from sqltable; $result = mysql_query($sql}; $connectodbc=odbc_connect("DSN","USERNAME","PASSWORD"); while($row = mysql_fetch_row($result)) { $sql="insert into accesstable

values($row["id",$row["name",$row["sex"],$row["email"])"; odbc_do($connectodbc,$sql); } odbc_close($connectodbc); mysql_close($conect); ?>

上文中就将mysql数据导入access数据库做了介绍，上文中的代码就能够帮助大家实现数据的导入。