mysql数据导出到access数据库
mysql数据库表sqltable
字段id,name,sex,email
access数据库表accesstable
id,name,sex,email
$connect = mysql_connect("localhost","","");
mysql_select_db("mydatabase");
$sql = "select * from sqltable;
$result = mysql_query($sql};
$connectodbc=odbc_connect("DSN","USERNAME","PASSWORD");
while($row = mysql_fetch_row($result))
{
$sql="insert into accesstable
values($row["id",$row["name",$row["sex"],$row["email"])";
odbc_do($connectodbc,$sql);
}
odbc_close($connectodbc);
mysql_close($conect);
?>
相关阅读:
JS点击复制地址发给QQ好友
javascript之textarea字数限制
Linux下22端口的修改
php+ajax中文乱码解决方法
JavaScript style属性详谈
linux命令之vi编辑器命令
弹出窗口代码大全
php随机打乱数组、字符串的函数
MYSQL远程连接ERROR 1130 is not allowed to connect to this MySQL server
CSS3实现文字渐变方法
CSS3之pointer-events详解
CSS3之text-shadow详解