Database Help
$30-100 USD
Paid on delivery
I have one database attached that has just one column showing a telephone number such as...
517-849-2811
I then have another database showing information such as....
**NPA-NXX Converted**
| NPA | NXX | Thousands | Designation |
| --- | --- | --------- | ----------- |
| 201 | 200 | | "RBOC" |
I want to use the NPA, NXX, and Thousands field to query my database containing the numbers in?
517-849-2811 format.
Then I want to write the designation next to the number such as
517-849-2811, RBOC
617-513-1353, CLEC
etc.
Now I am attaching two source files which both will always use the same format but I may have different data in any of the two. You basically need to read the first 6 or 7 digits and then carry the designation over to the other database and write it to the appropriate telephone numbers for which that designation applies. I need this done within 2-3 days as I have a deadline to meet.
I would like this ability to be built into an executable file where I can load my NPA-NXX as the source and then load my database and run the program to get the output file that I can use.
## Deliverables
Attached are the databases I spoke of in the above description of my project
Project ID: #3913185