[feffik]

Hi, I have a question about using php with a MS access db.

I want to copy some data from 1 database to another.
I got the code for this, mostly it works fine. But the problem is that with some data it doesn't copy all the data. It leaves out a row or something like that. or more then 1. Anyone got an idea to fix this???

///code

$sql="SELECT * FROM A";
$rf=odbc_exec($conn,$sql);
echo 'copying table A<BR>';
while (odbc_fetch_row($rf)){

$afd=odbc_result($rf,"AFD");
$naam=odbc_result($rf,"NAAM");



$wt = "insert into A (AFD, NAAM) values ('$afd', '$naam')";
odbc_exec($conn2, $wt);
}

/// end code

thnx.