Excel Formula or Access Database to scrub >1M phone numbers
Hi All,
Just wondering if some who knows a code (access) or formula in (excel). I have a DNC list and around millions of number needs to be scrub. I have tried it on excel however it takes time time to finished. Anyone who has database for that?
Any help will be appreciated.
Thank you
What kind of scrubbing do you need to do?
I have the list of DNC files and a list of phone numbers to be called but I need to know which ones are on DNC list.
Last edited by dark23; 10-14-2021 at 09:49 PM. Reason: typo
You can simplify the scrubbing by pasting the TO CALL NUMBERS in Col A and the DNC NUMBERS in Col B.
Then a comparison of the columns can be made at that point.
Excel has a row limit of 1,048,576. How many numbers are in your DNC list?
DNC numbers are more that 4M. I'm thinking of Macro but I don't know how.
DNC List exceed excel limit.
Like for example I do have the DNC list VA (804,757,434 and 540 area code) that will exceeds excel limit. If I do have almost 1M leads how can I scrub that using Macro? Is there anyway?Originally Posted by 6StringJazzer
Thanks
Excel has a row limit, but that is just for one column; you can use multiple columns. However, you have a lot of data. That is like three phone numbers for every man, woman, and child in the U.S. Just the DNC list would use 800 columns.
How many numbers do you have to scrub against that list?
This could certainly be done with a macro but I am guessing it would take quite some time to check just one number against the DNC list. A database would probably be a better choice. I have limited experience with Access so cannot provide a finished solution.
I agree with 6STringJazzer ... Excel is most likely not the way to go.
Did a quick search re: Excel and found this :
https://www.mrexcel.com/board/thread...6/page-2#posts
As indicated in the posts, Excel would probably take hours to process ...
Access does not have a row (record) limit. Its only limit is file size of 2 Gigs which should not be a problem. You could load each set of data into Access as tables and then run a query to join them and see which ones do not drop off the list. It would be a fairly simple task if all you are doing is comparing two lists.
Question: In what format are your source records that you wish to compare? Text files? .csv files?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks