EXCEL批量导入会员问题！-领先建站CMS提供服务商我们专注于CMS建站产品的研发

3168 查看	2 回复

主题：[IEXAM]EXCEL批量导入会员问题！ [收藏主题]

artedu 当前离线

760 主题	202 广播	11 粉丝

级别:六年级

用户积分:1600 分
登录次数:541 次
注册时间:2013/1/20
最后登录:2024/11/14

artedu 发表于：2016/5/4 10:59:48 | 显示全部帖子查看该作者主题楼主

做考试题库就用#科汛在线考试系统!

1，如果我想增加用户组或者部门选项，怎么操作？
2，我按官方给的EXCEL样表导入，第二步报错。
Server Error in '/' Application.

ERROR [42000] [Microsoft][ODBC Excel Driver] FROM 子句语法错误。 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Excel Driver] FROM 子句语法错误。

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC Excel Driver] FROM 子句语法错误。] System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +1231162 System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +1195 System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +67 System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +75 System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) +4 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94 Kesion.BLL.LabelSource.ReturnDataTable(Int32 dbtype, String connstr, String sqlstr, Boolean isUserDataBase) +1226 Kesion.NET.WebSite.Admin_UserImport.Button1_Click(Object sender, EventArgs e) +182 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1031

一分钟快速开通线上知识店铺