In Progress

Urgently need MSAccess scripting

This is a very simple project and I need it finished very very fast. I have an Access database ready with tables already designed and data populated. You will simply be formatting the data using queries and creating a CSV output file. There are various changes I need done to the existing system to make it more versatile.

Objective

This is an application that will be used in the telecommunication industry. Your objective will be to take various sets of pricing/vendor data and transform the information into a format that can be outputted as a CSV file.

Description

When a customer sends us a call over the internet, a switch decides which vendor to send to call to based on price. The switch will attempt the cheapest vendor first, if the call does not answer, the switch will try the next cheapest and the next until the call is completed. The switch can attempt up to 8 vendors before it gives up. Each vendor provides us a list of routes with a rate for each route. The switch does a digit match based on the first 7 digits of the number being called. For example, if the switch receives a call to 12148761404 it will look for a match in the system which would be 1214876. It then sends the call to the cheapest vendor to be completed. This system of sending calls to the cheapest vendor is called Least Cost Routing or LCR. In order for the switch to know how to route the calls, it requires that an LCR file be imported. Because there are anywhere from 50,000 to 150,000 routes per vendor, this task cannot be done by hand. An MS Access database has been prepared with all the rate and vendor data populated. You will only need to modify an application within Access to query all the rate tables and create various LCR tables.

Skills: .NET, ASP, Visual Basic

See more: visual basic cost, versatile it, rate visual basic, need format, format pricing, fast switch, cost format, access vendor database, database vendor, telecommunication, send query, route, need pricing, need order, lcr, cheapest, vendor price, sending price list system, match order, switch order, cost rate data, simple access order database, switch application, attempt, price match

About the Employer:
( 6 reviews ) San Francisco, United States

Project ID: #227501

13 freelancers are bidding on average $129 for this job

shmai

have a glance at PM. Regards,

$250 USD in 5 days
(181 Reviews)
7.0
HussienSharaf

HI, i m the best VBA/MS Access programmer . i have designed and implemented many successful DB systems on MS Access. plz check PM thanks

$200 USD in 4 days
(50 Reviews)
6.9
wsh2

Greetings Texas from the Keystone state of Pennsylvania.. {smile}. Texas writes: "There are various changes I need done to the existing system to make it more versatile." Silly question of me, but what makes you More

$229.95 USD in 2 days
(23 Reviews)
5.2
mingon

I've got a great experience in SQL and VBA. I can do this project. Regards, Sergey

$100 USD in 3 days
(9 Reviews)
4.8
momleetech

We can do it

$100 USD in 3 days
(9 Reviews)
3.8
rnari

will it finish today.i have lot experience in such jobs. regards, rnari.

$100 USD in 1 day
(2 Reviews)
1.9
mragavendra

Hi, I posses 5+yrs of experience in VB6,VBA, Excel, Access, Word, vb.net,RDBMS(SQL Server, Oracle) and sharepoint technologies. I have a sample of work for similar kind of project. I can do this job. pleas More

$170 USD in 2 days
(0 Reviews)
0.0
BDIIT

Im an access programmer and like ot do this for u..

$60 USD in 2 days
(0 Reviews)
0.0
Rayzweb

I can do this project for you very easily thru VBA programming itself. The task is so simple. I can send the converted CSV file within 8 hours of duration. I'm sure!!! Please send the database to me Thanks in adva More

$50 USD in 1 day
(0 Reviews)
0.0
ragavendram

Hi, I posses 5+ yrs of experience on VBA, VB6, Access, VB.net, SQL Server, Programmer. I can do this job. Thanks Ragavendra

$170 USD in 2 days
(0 Reviews)
0.0
svarogg

Hi. I'm an Experienced SQL/Access programmer, and can do this job easily. Please check PM.

$100 USD in 2 days
(0 Reviews)
0.0
ICoder3000

I Can Do the Job for u

$100 USD in 3 days
(0 Reviews)
0.0
zenonfly

Hello Sir, I have more than 5+ Years of experience in Developing and Testing web based and desktop Applications so I can do this job offering you a better quality of work. Thank You Darshan

$50 USD in 3 days
(0 Reviews)
0.0