将mysql数据导入access数据库 [ 网站地图 ]

发表于:2009-11-24 浏览:59 作者: 来源:站长资讯网

关键字:数据库,MYSQL,ACCESS

描述:mysql数据库表sqltable字段id,name,sex,emailaccess数据库表accesstableid,name,sex,email<?      $connect=mysql_connect("localhost","","");   

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

 


站长资讯网 做中国最丰富的资讯网站 沪ICP备05004089号