National Do Not Call Registry

  • Thread starter Thread starter Devin Holloway
  • Start date Start date
D

Devin Holloway

I'm interested in combining prospecting data with data
from the national do not call registry using MS Access
2003. Does anyone have experience creating databases
similar to this one? How complex are these types of
databases? Thanks in advance.

Best,

Devin
 
I'm interested in combining prospecting data with data
from the national do not call registry using MS Access
2003. Does anyone have experience creating databases
similar to this one? How complex are these types of
databases? Thanks in advance.
Click to expand...

This is NOT trivial. The Registry surely has tens of millions of
entries at this point, probably more than a JET database can handle.
You may want to look into a client-server solution (in SQL/Server,
MySQL, or Oracle for instance), perhaps with Access as a frontend.
 
What about phone numbers specific to a single region?
Since we can only access a few area codes (free of
charge) I figure that MS Access may work for this job. I
couldn't see all the numbers in 3 area codes amounting to
more than a million, but I could be wrong.

Though not trivial, what can I do to get started on this
database? Are there any sources that provide
specifics/details about setting up these kinds of DBs?

Any help is appreciated.

Best,

Devin
 
Though not trivial, what can I do to get started on this
database? Are there any sources that provide
specifics/details about setting up these kinds of DBs?
Click to expand...

It should be pretty straightforward (in principle). I haven't
investigated the DoNotCall list from the vendor point of view (I'm on
it as a consumer though!), so I'm not certain just what you get; but
whatever format it's in, you should be able to Import it into a
DoNotCall table.

Put a unique Index on the phone number field, and you'll be able to
create an Update query to delete all do-not-call numbers from your
calling list; or exclude them from consideration using an "unmatched
query wizard" query.
 
Back
Top