将access的数据库建立一个"system DSN";
根据access数据库中各表的名称,在mysql中建立相应的各个空表
<?
function update($field1,$field2,$field3,$field4)
{
mysql_connect("localhost","root","");
mysql_select_db("code"); mysql_query("insert into yb (xh,yb,mc,zfq) values ('$field1','$field2','$field3','$field4')");
}
$connectodbc=odbc_pconnect("mydb","","");
$queryodbc="select XH,YB,MC,ZFQ from yb";
$resultodbc=odbc_do($connectodbc,$queryodbc);
echo "Open successfully!!";
while(odbc_fetch_row($resultodbc))
{ $sp1=odbc_result($resultodbc,1);
$sp2=odbc_result($resultodbc,2);
$sp3=odbc_result($resultodbc,3);
$sp4=odbc_result($resultodbc,4);
update($sp1,$sp2,$sp3,$sp4);
}
echo "Converted successfully!";
?>
根据access数据库中各表的名称,在mysql中建立相应的各个空表
<?
function update($field1,$field2,$field3,$field4)
{
mysql_connect("localhost","root","");
mysql_select_db("code"); mysql_query("insert into yb (xh,yb,mc,zfq) values ('$field1','$field2','$field3','$field4')");
}
$connectodbc=odbc_pconnect("mydb","","");
$queryodbc="select XH,YB,MC,ZFQ from yb";
$resultodbc=odbc_do($connectodbc,$queryodbc);
echo "Open successfully!!";
while(odbc_fetch_row($resultodbc))
{ $sp1=odbc_result($resultodbc,1);
$sp2=odbc_result($resultodbc,2);
$sp3=odbc_result($resultodbc,3);
$sp4=odbc_result($resultodbc,4);
update($sp1,$sp2,$sp3,$sp4);
}
echo "Converted successfully!";
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货