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); ?>;;【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】;;;;