Copy mysql data to access database_PHP tutorial

mysql database table sqltable
Fields id, name, sex, email
access database table 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 ; 🎜>



http://www.bkjia.com/PHPjc/631211.html

www.bkjia.com

true