用PHP怎么写,我的写法是:
include("./adodb/adodb.inc.php");
$conn=new com("adodb.connection");
$connstr="driver={microsoft excel driver(*.xls)};dbq=".realpath("membership.xls");
$conn->open($connstr);
$sql="select * from [Sheet1$]";
$rs=$conn->execute($sql);
/*
while(!$rs->eof)
{
$fields=$rs->fields(Name);
$Name=$fields->value;
$fields=$rs->field(Item);
$Item=$fields->valud;
$query="insert into gbmember(Name,Item) values('$Name','$Item')";
mysql_query($query);
$rs->movenext;
}*/注释后还是出现这样的错误:
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序' in C:\App\216\yi\savetomysql.php:38 Stack trace: #0 C:\App\216\yi\savetomysql.php(38): com->open('driver={microso...') #1 {main} thrown in C:\App\216\yi\savetomysql.php on line 38;
高手请指导一下!哪里出错了
include("./adodb/adodb.inc.php");
$conn=new com("adodb.connection");
$connstr="driver={microsoft excel driver(*.xls)};dbq=".realpath("membership.xls");
$conn->open($connstr);
$sql="select * from [Sheet1$]";
$rs=$conn->execute($sql);
/*
while(!$rs->eof)
{
$fields=$rs->fields(Name);
$Name=$fields->value;
$fields=$rs->field(Item);
$Item=$fields->valud;
$query="insert into gbmember(Name,Item) values('$Name','$Item')";
mysql_query($query);
$rs->movenext;
}*/注释后还是出现这样的错误:
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序' in C:\App\216\yi\savetomysql.php:38 Stack trace: #0 C:\App\216\yi\savetomysql.php(38): com->open('driver={microso...') #1 {main} thrown in C:\App\216\yi\savetomysql.php on line 38;
高手请指导一下!哪里出错了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货