If you really need to optimize you could progress in parallel in two sorted
lists (you'll have the initial sort cost, then you'll basically browse each
list once in parallel to find out the difference).
I would try that only once I'm 100% sure the simpelst approach is not quick
enough...
--
Patrice
"John Wright" <riley_wright@xxxxxxxxxxx> a écrit dans le message de groupe
de discussion : eLyhk7F3IHA.4536@xxxxxxxxxxxxxxxxxxxxxxx
I have two datatables that I load. One I load from LDAP, the other gets
loaded from Excel. I need to check to see which names are in the LDAP
that are not in the Excel table and vica versa. There are about 300
records in each. Short of a brute force attack on this, does anyone have
an elegant way to list the non-matches in each table?
Re: COMBINING 2 DATA TABLES FROM 2 DIFFERENT SOURCES ... What I'm about to say may result from my limited knowledge of Excel, but I'm not sure, in Excel, how to automatically link records from different lists and update a linking field to show that they match. ... Then I marked the MLS records with the same corresponding number as it's parcel ID counterpart, ...Sales Date ... (microsoft.public.access.gettingstarted)
Re: Import contacts from outlook ... Gord Dibben MS Excel MVP... to the excel worksheet, why is it that in the address field, there are marks ... The Import and Export Wizard in Outlook makes it easy to export contact ... different address lists you might have stored in Outlook, ... (microsoft.public.excel.misc)
Re: COMBINING 2 DATA TABLES FROM 2 DIFFERENT SOURCES ... marked the MLS records with the same corresponding number as it's parcel ID ... > the matching record in the other list, and then re-filter both lists to ... > Access provides more safeguards than Excel against accidentally ... >>>Sales Date ... (microsoft.public.access.gettingstarted)
Re: Paper Data Entry Form ... Consider creating a Word (or Excel) document that depicts what you need it ...Jeff Boyce... frequency of data entry errors, since it's touched once, not twice. ... having some drop-down lists obscuring other dropped-down lists, ... (microsoft.public.access.forms)
Re: scanning excel list for invalid e-mail addresses ... The formula is too long for Excel 2003 and earlier versions - for some ... and copy the resulting worksheet to your main ...lists: a full recalculation of ~22,000 email addresses took 70 seconds ... It uses regular expressions, and the regex can either be hard coded in the UDF,... (microsoft.public.excel.misc)
