php版本用php5.3.29，如果提示错误Failed to create COM object `ADODB.Connection'   

解决方法：https://taotaoit.com/article/details/1703.html

<?php
header('Content-Type: text/html; charset=utf-8');
// MySQLi - 面向过程
$servername = "localhost";
$username = "root";
$password = "root";
$database = "zhtcms_moban";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $database);
// 检测连接
if (!$conn) {
    die("连接失败：" . mysqli_connect_error());
}
// 修改数据库连接字符集为 utf8
mysqli_set_charset($conn,"utf8");

// php连接access数据库
$datapath="abc.mdb";  
$catId="1";  
$conn2 = new com("ADODB.Connection");  
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath($datapath);
$conn2->Open($connstr);  
$rs = new com("ADODB.RecordSet");  
$rs->Open("select * from News ",$conn2,1,1); //查询*.MDB文件里面的
// var_dump($rs);
//一边读一边写
while(!$rs->eof) {  
 
  //以下是分别给变量赋值，其中'gb2312','utf-8'为了解决乱码问题！
  $id =iconv('gb2312','utf-8',$rs->Fields["id"]->value);//ID为access字段,或用数字表示  
  $title =iconv('gb2312','utf-8',$rs->Fields["title"]->value); 
  $content=iconv('gb2312','utf-8',$rs->Fields["content"]->value);  
  $addtime =iconv('gb2312','utf-8',$rs->Fields["infotime"]->value);  
  $hits =iconv('gb2312','utf-8',$rs->Fields["hits"]->value);  
   
  echo "<font color=red>".$title."</font>已经插入<br>";//输出插入记录  
  ///依次执行insert，值为变量
 $sql="INSERT INTO `zht_articles`(`articleId`,`catId`,`articleTitle`,`articleContent`,`createTime`,`sortNum`,`staffId`,`articleFlag`) VALUES ('','{$catId}','{$title}','{$content}','{$addtime}','{$hits}','1','1')";
 mysqli_query($conn,$sql); //执行语句！！！  
  $rs->MoveNext();  
  /////个人用于ACCESS向mysql内转换数据库的操作, 
  }
?>

如果access编码是gb2312，当前页面编码是utf-8

那么直接在sql语句中检索汉字，是检索不到结果的，如：

$rs->Open("select * from News where SmallClassName='企业新闻' ",$conn2,1,1); //查询*.MDB文件里面的

改为：

$key =iconv('utf-8','gb2312','企业新闻'); 
$rs->Open("select * from News where SmallClassName='".$key."' ",$conn2,1,1); //查询*.MDB文件里面的