private SqlConnection OleToSql(OleDbConnection con)
        {
            string constring = con.ConnectionString;
            if (constring.Substring(0, 4).ToLower().Trim() == "file")
            {
                string file = constring.Split('=')[1].Trim();
                constring = File.ReadAllText(file);
            }
            string[] ss = constring.Split(';');
            var keys = new KeyValuePair<string, string>[ss.Length];
            for (int i = 0; i < ss.Length; i++)
            {
                if (ss[i].Split('=').Length > 1)
                {
                    keys[i] = new KeyValuePair<string, string>(ss[i].Split('=')[0].Trim(), ss[i].Split('=')[1].Trim());
                }
            }
            var strbldr = new SqlConnectionStringBuilder
            {
                DataSource = keys.Where(t => t.Key == "Data Source").Select(t => t.Value).First(),
                InitialCatalog = keys.Where(t => t.Key == "Initial Catalog").Select(t => t.Value).First(),
                UserID = keys.Where(t => t.Key == "User ID").Select(t => t.Value).First(),
                Password = keys.Where(t => t.Key == "Password").Select(t => t.Value).First(),
                PersistSecurityInfo = keys.Where(t => t.Key == "Persist Security Info").Select(t => t.Value.ToLower() == "true").First()
            };
            var sqlcon = new SqlConnection(strbldr.ConnectionString);
            return sqlcon;
        }