string _excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;""";
            _excelConnectionString = string.Format(_excelConnectionString, _FinalPath).Trim();

            using (OleDbConnection _OleDbConnection = new OleDbConnection(_excelConnectionString))
            {
                _OleDbConnection.Open();
                OleDbCommand _OleDbCommand = new OleDbCommand("SELECT * FROM " + _SheetName, _OleDbConnection);
                _OleDbCommand.CommandType = CommandType.Text;
                OleDbDataReader oledbReader = _OleDbCommand.ExecuteReader();
                DataTable dt = new DataTable();
                if (oledbReader.HasRows)
                {
                    dt.Load(oledbReader);
                }
                DataColumn columnUploadDoccument = new DataColumn("intUploadDocumentId");
                columnUploadDoccument.DataType = System.Type.GetType("System.Int32");
                columnUploadDoccument.DefaultValue =_DocumentID;
                dt.Columns.Add(columnUploadDoccument);

                DataColumn columnUserId = new DataColumn("intUserID");
                columnUserId.DataType = System.Type.GetType("System.Int32");
                columnUserId.DefaultValue =intUserId;
                dt.Columns.Add(columnUserId);

                string _SQLConnectionString = DAL.insight_ConnectionString;

                using (SqlBulkCopy _BulkCopy = new SqlBulkCopy(_SQLConnectionString))
                {

                    for (int i = 0; i < _ColumnCount; i++)
                    {
                        _BulkCopy.ColumnMappings.Add(dt.Columns[i].ToString(), ListTableColumn[i]);
                    }
                    _BulkCopy.DestinationTableName = _TableName;
                    _BulkCopy.WriteToServer(dt);
                }

            }

            Status = true;