EXCEL 导入SQL Server2000

#region 导入Excel表
public void ExcelImport(string filename)
{
string selectfile="";
if(SystemIOPathGetExtension(SelectFilePostedFileFileName)=="xls")
{
if ( SelectFilePostedFileFileName != "")
{
string path=getPath()+"document\\";
//string fileName = SystemIOPathGetFileName(SelectFilePostedFileFileName);//返回本地指定路径字符串的文件名和扩展名
string fileName = SystemIOPathGetFileNameWithoutExtension(SelectFilePostedFileFileName)+"_"+getDateTime()+SystemIOPathGetExtension(SelectFilePostedFileFileName);
selectfile = SystemIOPathCombine(path,fileName);
//以跨平台方式(Path)，合并两个路径字符串——即Web服务器上的指定虚拟路径相对应的物理文件路径、本地指定路径字符串的文件名和扩展名
SelectFilePostedFileSaveAs( selectfile);//保存上载文件的内容
}
try
{
string UserID ="";
string roleID = "";
string conStr = " Provider = MicrosoftJetOLEDB40 ; Data Source=" + selectfile + "; Extended Properties=\"Excel 80;HDR=YES;IMEX=1\"";
string sql = "select from [sheet1$]";
OleDbConnection bconn = new OleDbConnection(conStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sql,bconn);
ds = new DataSet();
odaFill(ds);
S0003_DataEntity daS0003 = new S0003_DataEntity();
for(int i=0;i<dsTables[0]ColumnsCount;i++)
{
UserID = dsTables[0]Columns[0]ColumnName;
roleID = dsTables[0]Columns[1]ColumnName;
}
if(UserIDEquals("用户ID")&&roleIDEquals("角色ID"))
{
thislblMessageText = "导入的Excel不匹配或Excel文件正在被执行。";
}
for(int i = 0;i < dsTables[0]RowsCount;i++)
{
daS0003_CUserID = dsTables[0]Rows[i][0]ToString()Trim();
daS0003_CRoleID = dsTables[0]Rows[i][1]ToString()Trim();
daS0003_CCreater = dsTables[0]Rows[i][2]ToString()Trim();
daS0003_DCrtTime = dsTables[0]Rows[i][3]ToString()Trim();
daS0003_CUpdater = dsTables[0]Rows[i][4]ToString()Trim();
daS0003_DUpdTime = dsTables[0]Rows[i][5]ToString()Trim();
thisExcelInsertUserInfo(daS0003);
thislblMessageText = "数据导入成功。";
S0007de_CFunCode = "S0007";
S0007de_CMsgID = "M007000";
S0007de_CBlackName = "用户角色管理";
S0007de_VCMsg = "导入数据成功";
S0007de_VCTrack = "";
S0007de_VCErrDetail ="";
S0007de_DCrtTime = cgsdtstrTime();
logAddLogInfo(S0007de);
}
}
catch(Exception ex)
{
thislblMessageText="导入数据表失败，导入的Excel不匹配或Excel文件正在被执行。";
S0007de_CFunCode = "S0007";
S0007de_CMsgID = "M007000";
S0007de_CBlackName = "用户角色管理";
S0007de_VCMsg = "导入数据失败";
S0007de_VCTrack = "public void ExcelImport(string filename) ";
S0007de_VCErrDetail =exMessage;
S0007de_DCrtTime = cgsdtstrTime();
logAddLogInfo(S0007de);
}
}
}
#endregion

假如出现宽带故障，您可先通过以下方法进行排障：
〖1〗使用单机拨号，如有使用路由器，请暂时断开路由器测试；
〖2〗重启modem和电脑；
〖3〗重新创建宽带拨号连接，再拨号尝试。 *** 作方法：开始＞程序＞附件＞通迅＞新建连接向导。
若自行排障仍然没有恢复，可联系人工客服进行申告故障

select into t# FROM openrowset( 'MicrosoftJetOLEDB40',
'EXCEL 50;HDR=YES;IMEX=1; DATABASE=d:\kq\salaryxls',Sheet1$)
上面是在sql server查询分析器直接导入数据，意思是将d:\kq\salaryxls的sheet1导入到sql server的表t#(该语句会新建表，如果sql server已经存在该表会报错)

---