<?
$Cn = new COM( "ADODB.Connection" );
$Cn->CursorLocation = 3;
$Server = "C:\\tmp\\mdb\\AC97管理.mdb";
$ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;";
$ConnectionString .= "Data Source=$Server;";
$Cn->Open( $ConnectionString );
$Rs = $Cn->OpenSchema( 4 );
$Rs->Filter = "TABLE_NAME = 'T_生年月日'";
$Rs->Sort = "ORDINAL_POSITION";
while( !$Rs->EOF ) {
print "{$Rs->Fields[2]->Value} | {$Rs->Fields[3]->Value}<br>";
$Rs->MoveNext();
}
$Rs->Close();
$Cn->Close();
?>
|