这个问题我已经回答过了。
http://community.csdn.net/Expert/topic/3535/3535603.xml?temp=.7161219
myCommand.Fill(myDataSet,"表1");
myCommand.Fill(myDataSet,"表2");
http://community.csdn.net/Expert/topic/3535/3535603.xml?temp=.7161219
myCommand.Fill(myDataSet,"表1");
myCommand.Fill(myDataSet,"表2");
等会给你结贴,还想问个问题;
能不能这样一次就填充好两个表呢
strSql = ""Select * from [Sheet3$];Select * from [磁带说明$];"";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strSql,conn);
myCommand.TableMappings.Add(dtSheetName.Rows[0]["TABLE_NAME"].ToString() + i.ToString(),dtSheetName.Rows[i]["TABLE_NAME"].ToString());
myCommand.Fill(myDataSet);