多种文件做数据源的连接方法

下面有详细方法:
http://www.connectionstrings.com/default.aspx
导入的文件下必须有一个命名为"Schema.ini"的配置文件，如何配置，上面的网址里有详细说明.
如下示例:

string  dir = Path.GetDirectoryName(filePath);
         string  filename = Path.GetFileName(filePath);
         string  conStr  =   string .Format( " Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\;Extended Properties=\ " text;HDR = Yes;FMT = Delimited(,)\ " ; " , dir);
         using  (OleDbConnection oledbCon  =   new  OleDbConnection(conStr))
         {
            OleDbDataReader reader=null;
            OleDbCommand oledbCom = new OleDbCommand();
            oledbCom.Connection = oledbCon;
            oledbCom.CommandText = string.Format("select top 1 * from {0}", filename);

            try
            {
                oledbCon.Open();
                reader = oledbCom.ExecuteReader();            }
            catch (SqlException e)
            {
                throw new Exception(e.Message);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }
            }
        }

转载于:https://www.cnblogs.com/wudingfeng/archive/2008/03/01/1086946.html