<?
$conn = @new COM("ADODB.Connection") or die("ADO 连接创建失败!");
$rs = @new COM("ADODB.RecordSet") or die("ADO 记录集创建失败!");
$conn->open("Provider=MSDASQL.1;Data Source=odbc1;");
$rs = $conn->Execute("SELECT * FROM table1 ORDER BY id DESC;");
$row=1;
echo "<table border=1>";
while(!$rs->EOF)
{
echo "<tr>";
for($col=0;$col<$rs->Fields->Count;$col++)
{
echo "<td>";
echo $rs->Fields[$col]->Name.":".$rs->Fields[$col]->Value;
echo "</td>";
}
$row++;
echo "</tr>";
$rs->MoveNext();
}
echo "</table>";
$rs->Close;
$conn->Close;
?>
$conn = @new COM("ADODB.Connection") or die("ADO 连接创建失败!");
$rs = @new COM("ADODB.RecordSet") or die("ADO 记录集创建失败!");
$conn->open("Provider=MSDASQL.1;Data Source=odbc1;");
$rs = $conn->Execute("SELECT * FROM table1 ORDER BY id DESC;");
$row=1;
echo "<table border=1>";
while(!$rs->EOF)
{
echo "<tr>";
for($col=0;$col<$rs->Fields->Count;$col++)
{
echo "<td>";
echo $rs->Fields[$col]->Name.":".$rs->Fields[$col]->Value;
echo "</td>";
}
$row++;
echo "</tr>";
$rs->MoveNext();
}
echo "</table>";
$rs->Close;
$conn->Close;
?>
<?
require "includes/adodb/tohtml.inc.php";
require "includes/adodb/adodb.inc.php";
$db = &ADONewConnection("ado_access");
print "<h1>Connecting $db->databaseType...</h1>";
$access = 'test.mdb';
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';';'USER ID=;PASSWORD=;'; if (@$db->PConnect($myDSN, "", "", "")) {
print "ADO version=".$db->_connectionID->version."<br>";
$sql="select name,sex from test";
$rs=$db->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));
} else print "ERROR: Access test requires a Access database $access".'<BR>'.$db->ErrorMsg();
?>adodb介绍和下载
http://php.weblogs.com/adodb/
mysql_connect("MS Access Database","user","pwd");
用连MYSQL的方法来连ACCESS?
我记得应该借助ODBC来连..具体也不清楚, 因为基本上没用过.:P
不过xxsa方法倒是简单。我会去试试。谢谢上面的几位了。