php怎样访问access数据库，读取里面的内容

Question

如题，php怎样连接access数据库，读取里面的内容

Answer 1

这个是我以前用的

define('ACCESS_DB_DRIVER',   '{Microsoft Access Driver (*.mdb, *.accdb)}');
define('ACCESS_DBQ',         'C:\\test\\test_be.accdb');
define('ACCESS_DB_USER',     '');
define('ACCESS_DB_PASSWORD', '');

$objPdo = new PDO("odbc:Driver=" . ACCESS_DB_DRIVER . ";Dbq=" . ACCESS_DBQ . "; Uid=" . ACCESS_DB_USER . "; Pwd=" . ACCESS_DB_PASSWORD . " ;");