xiaoyaoyou - 2009-12-8 14:21:30
string strConn;
加载数据驱动
strConn1 = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;" +
//"Data Source="d:\朱臣Exce\lBook2.xls";User ID=Admin;Password=zhuchen;Extended properties=Excel 5.0')xactions$;
指定要到如的数据源
"Data Source="c:zc.mdb";
//Extended Properties=Excel 5.0;";
strConn2 = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;" +"Data Source=c:Book2.xls";
OleDbConnection conn = new OleDbConnection(strConn);
string sql;
从表格中得到数据
sql = "SELECT * FROM ["+sheet1+"$]";
set rs = strConn2.execute(sql);
循环插入数据
while not rs.eof ;
sql = "insert into xxx([a],,[c],[d]) values('"& fixsql(rs(0)) &"','"& fixsql(rs(1)) &"','"& fixsql(rs(2)) &"','"& fixsql(rs(3)) &"')";
strConn1.execute(sql);
rs.movenext;
wend;
连接数据库
OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, strConn);
DataSet myDataSet = new DataSet();
绑定数据
myCommand.Fill(myDataSet);
return myDataSet.Tables[0];
strConn1.close;
set strConn1 = nothing;
set strConn1.close;
set strConn2 = nothing;