[转载]mysql数据复制到access数据库

信息来源：紫琦的Blog

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);
?>