C#获取Excel和Access连接的写法

C#获得Excel和Access数据源连接的方法：

        /// <summary>

        /// 获取Excel连接
        /// </summary>
        /// <param name="fileName">Excel文件名(包括路径)</param>
        /// <returns>返回连接对象</returns>
  
  
        private OleDbConnection GetExcelConn(string fileName)
        {
            string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=" + fileName + ";" +
                "Extended Properties=Excel 8.0;";
            OleDbConnection objConn = new OleDbConnection(sConnectionString);
            return objConn;
        }
        /// <summary>

        /// 获得Access连接
        /// </summary>
        /// <param name="fileName">Access文件名(包括路径)</param>
        /// <returns>返回连接对象</returns>
  
   
  
  
        private OleDbConnection GetAccessConn(string fileName)
        {
            string conStr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source = " + fileName;
            OleDbConnection objConn = new OleDbConnection(conStr);
            return objConn;
        }