by Drew Wutka (2 Submissions)
Category: Complete Applications
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (4 Votes)
Generic Utility to compare an Access Table with an Excel SpreadSheet. Neither Microsoft Access, nor Microsoft Excel needs to be installed to use this, since it uses ADO to compare the files. Multi session settings can be saved. This is a complete VB project. A precompiled Installation/Setup is available on my site, https://wolfwares.com
Assumes
The settings database needs to be in the same directory as the source/.exe.
Side Effects
Allowing this utility to update existing records or add missing records is an option. I recommend that you backup your files before you use these options.
Download Access / Excel Comparer (27 KB)