-create your access database,

-copy paste below code in your file and run it,

-check your access file name in below code line 2

<?php

$db_conn = new COM(“ADODB.Connection”);
$connstr = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=”. realpath(“./yellow.mdb”).”;”; //access database file
$db_conn->open($connstr);
$rS = $db_conn->execute(“SELECT * FROM YPDATA”);
$f1 =  $rS->Fields(0); //for first column
$f2 =  $rS->Fields(1); //for second column

$cocd = $rS->Fields(0);
$conm = $rS->Fields(2);
$stscd = $rS->Fields(3);
$web = $rS->Fields(9);

while (!$rS->EOF)
{

print $f1->value.” “.$f2->value.”<br />\n”;
$rS->MoveNext();

}
$rS->Close();
$db_conn->Close();
?>