找到一个函数,不过没验证过
<? 
function update($field1,$field2,$field3) 

mysql_pconnect("localhost","",""); 
mysql_select_db("DATABASENAME"); 
mysql_query("insert into tablename (field1,field2,field3) values ('$field1','$field2','$field3')"); 

$connectodbc=odbc_pconnect("DSN","USERNAME","PASSWORD"); 
$queryodbc="select field1,field2,field3 from tablename"; 
$resultodbc=odbc_do($connectodbc,$queryodbc); 
echo "Open successfully!!"; 
while(odbc_fetch_row($resultodbc)) 

$spbh=odbc_result($resultodbc,1); 
$spmc=odbc_result($resultodbc,2); 
$cplx=odbc_result($resultodbc,3); 
update($spbh,$spmc,$cplx); 

echo "Converted successfully!"; 
?>