Access / Excel Comparer
Drew Wutka
(2 Submissions)
Complete Applications
Visual Basic 5.0
Intermediate
Wed 3rd February 2021
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.
Rate Access / Excel Comparer
(4(4 Vote))
(4(4 Vote))
Download Access / Excel Comparer
Active Server Pages
Coding Standards
Complete Applications
Custom Controls
Data Structures
Databases / ADO
DDE
Debugging & Errors
DirectX
Encryption
Files / I/O
Games
Graphics
Internet / HTML
Jokes / Humor
Libraries
Math / Dates
Office / VBA
Miscellaneous
OOP
OLE / COM / ActiveX
Registry
Sound / MP3
String Manipulation
VB Enhancements
Windows API
Windows CE
System Services