從指定的Excel檔案匯入

從指定的Excel檔案匯入
        public DataSet ImportFromExcel(string strFileName)
        {
            DataSet ds = new DataSet();
            ds = doImport(strFileName);
            return ds;
        }

        //執行匯入
        private DataSet doImport(string strFileName)
        {
            if(strFileName=="") return null;
            strConn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+strFileName+";Extended Properties=Excel 8.0";           
            OleDbDataAdapter excelDA = new OleDbDataAdapter("select * from [Sheet1$]",this.strConn);
            DataSet ExcelDs = new DataSet();
            try
            {
                excelDA.Fill(ExcelDs,"ExcelInfo");
            }
            catch            {

            }
            return ExcelDs;
        }

把excel檔案中的資料匯入DataSet或DataTable,然後再往庫裡導.