http://msmvps.com/blogs/officept/archive/2009/04/22/vsto-access-detect-if-tables-are-similar.aspxpublic bool TablesAreEqual( string MyTableSource, string MyTableToCompare, string MyIndexField) { try { OleDbConnection cnn; using (DataSet ds = new DataSet()) { OleDbDataAdapter da; string cs = oAccess.CurrentProject.Connection.ToString(); string strSQLenCommunityServer 2008.5 SP2 (Build: 40407.4157)