I have been using Fuzzy Lookup in Excel with great success, usually after pulling data from two different sources into a sheet and crunching away.
I'm now trying to compare two very large tables and wanted to see if I can skip the step of trying to bring the data to a single sheet and instead query against two tables in an Access DB.
Prior threads on the topic are from back in 2015, wondering if anyone has experience doing this more recently. Am using O365 32-bit for both Excel and Access.
Anyone pull this off?
I'm now trying to compare two very large tables and wanted to see if I can skip the step of trying to bring the data to a single sheet and instead query against two tables in an Access DB.
Prior threads on the topic are from back in 2015, wondering if anyone has experience doing this more recently. Am using O365 32-bit for both Excel and Access.
Anyone pull this off?