Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.'); //$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.'); $sql = 'SELECT ProductName, QuantityPerUnit, UnitPrice FROM Products ORDER BY ProductName'; $rs = $conn->Execute($sql); ?> EOF) { ?> MoveNext() ?>

Product Name	Quantity Per Unit	Unit Price
Fields['ProductName']->Value ?>	Fields['QuantityPerUnit']->Value ?>	Fields['UnitPrice']->Value ?>

Close(); $conn->Close(); $rs = null; $conn = null; ?>