Hello,
I have a constant struggle to validate large amounts of data (specifically phone numbers), against quite a few comparison variables.
So far I have a "scrub" template. I have approximately 10 worksheets, each with very different reasons for seperation, but all of them consisting of the phone number or valid npanxx (area code-exchange). The issue that I am having is that once I do my initial formatting on the raw data, and then copy and paste my formulas the excel sheet eventually times out (too many comparisons I think, taking too much memory).
So I was thinking of off-loading the work to a server, or at least reducing the required "in memory" foot print so that the time-outs stop happening.
I was thinking of loading all the comparison data into a mysql Db (I have one running on a fast access server), and then running an excel macro that compares all the raw data against the comparison data in the Db (usually two specific columns of data, usually 40k rows or more).
However, I'm not even sure if this is possible?
Is it possible to :
1) row by row, compare the value of a specific cell, against multiple tables in
a mysql database, and if so, "mark" another cell with a specified indicator?
Would this be more effecient to use a mysql db? or an access Db (which I
know nothing of how to use.. lol)
Any help, suggestions, comments, sample code would be greatly apreciated.
Spyrule.
Bookmarks