Ejemplo n.º 1
0
        /// <summary>
        /// Creates a OleDbConnection to an comma seperated values(*.csv) file using the provider Microsoft.Jet.OleDb.4.0
        /// </summary>
        /// <param name="fileInfo"></param>
        /// <returns></returns>
        public static OleDbConnection CsvOleDbConnection(FileInfo fileInfo)
        {
            string provider           = "Microsoft.Jet.OleDb.4.0";
            string dataSource         = fileInfo.DirectoryName;
            string extendedProperties = "text;HDR=Yes;Format=CSVDelimited";

            return(OleDbConnectionBuilder.CreateConnection(provider, dataSource,
                                                           extendedProperties));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Creates a OleDbConnection to an excel (*.xlsx) file using the provider Microsoft.Ace.OleDb.12.0
        /// </summary>
        /// <param name="fileInfo"></param>
        /// <returns></returns>
        public static OleDbConnection ExcelAceOleDbConnection(FileInfo fileInfo)
        {
            string provider           = "Microsoft.Ace.OleDb.12.0";
            string dataSource         = fileInfo.FullName;
            string extendedProperties = "Excel 12.0 Xml;HDR=Yes;IMEX=1";

            return(OleDbConnectionBuilder.CreateConnection(provider, dataSource,
                                                           extendedProperties));
        }