<? 
mysql_connect("localhost","root","zebtech"); 
mysql_select_db("schooldb");
$result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info"); $connectodbc=odbc_pconnect("accodbc","",""); 
while ($stu=mysql_fetch_row($result)){
$queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";  
$resultodbc=odbc_do($connectodbc,$queryodbc); 
}?> 
<html><head><title>学生数据导出(mysql->access)</title></head><body>
<br><br><br><center>数据导出完成,请关<a href=# onclick=window.close()>闭此</a>窗口,不要再次刷新,否则可导致数据重复!</center>
</body></html>

解决方案 »

  1.   

    <? 
    mysql_connect("localhost","root","zebtech"); 
    mysql_select_db("schooldb");
    $result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info"); $connectodbc=odbc_pconnect("accodbc","",""); 
    while ($stu=mysql_fetch_row($result)){
    $queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";  
    $resultodbc=odbc_do($connectodbc,$queryodbc); 
    }?> 
    <html><head><title>学生数据导出(mysql->access)</title></head><body>
    <br><br><br><center>数据导出完成,请关<a href=# onclick=window.close()>闭此</a>窗口,不要再次刷新,否则可导致数据重复!</center>
    </body></html>
      

  2.   

    schooldb为mysql的数据库,accodbc为数据源,连接access数据库