62,025
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO 表名 SELECT * FROM
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=d:\book1.xls',sheet1$)
string myConnStringExcel = "Provider=Microsoft.Jet.OLEDB.4.0; Extended Properties=Excel 8.0; Data Source= " + Application.StartupPath + "\\data.xls";
myConnectionExcel = new OleDbConnection(myConnStringExcel);
myConnectionExcel.Open();
string mySelectQuery;
OleDbCommand myCommand;
OleDbDataReader readerExcel;
mySelectQuery = "SELECT * FROM [Sheet1$]";
myCommand = new OleDbCommand(mySelectQuery, Program.myConnectionExcel);
readerExcel = myCommand.ExecuteReader();
while(true)
{
if (!readerExcel.Read()) break;
// 在这里使用Excel表中的字段
}
readerExcel.Close();
myConnectionExcel.Close();