In Progress

Import Utility for MS Access Database that doesn't require Access to run

I need a VERY user-friendly import program for CounselPro, a relational database that we store in Access 2000. The program should be able to operate on its own, without the user being required to have Access installed on their computer. It must run in Windows 98 SE, Windows 2000 and Windows XP and be able to import data into a data file that resides on a network drive.

**BACKGROUND/CHALLENGE TO SOLVE:**

The challenge on imports is that we need to take flat text from .csv or excel formats and import it to CounselPro's relational database format, which involves building primary and foreign keys, based upon a number that resides in a table named "utility." The CounselPro program uses that number as a universal number incrementing resources, so that any record added via ODBC to any table in the database has a truly unique record ID number, not relying on MS Access to build record id's using its own built-in autonumbering feature. Therefore, as we add new records to tables, we increment the number in utility so that we do not add duplicate id numbers in any table.

A detailed description is included in the attached zip file, along with the database schema we are using.

NOTE: We are not open to rewriting or re-engineering the database schema or numbering process at this time, so please don't bid unless you can work with the schema as currently designed.

## Deliverables

1) Complete and fully-functional working program, in executable form, and ready to run in Windows 98 SE, 2000 and XP.

2) Uncompiled source code that we could use to modify program in the future if necessary.

3) Complete information about programming environment and compiler used.

4) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows 98 SE, Windows 2000 and Windows XP.

It must NOT require that the user have MS Access on the computer. It may use the ODBC driver setting we have to access the database in its location, usually on a network drive.

Skills: Data Entry, Engineering, Microsoft Access, MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: programming in access database, programming in access, programming access database, ms new hire, ms excel programming for hire, ms excel programming, ms access programming, excel challenge, excel and access programming, excel access programming, Driver for hire, c# programming challenge, c programming challenge, computer utility program, computer programming using excel, computer programming for hire, computer network programming, challenge programming, buyer require, at&t programming, are you ready for a challenge, uses for excel, process re-engineering, program for computer, windows universal

About the Employer:
( 13 reviews ) United States

Project ID: #3207719

Awarded to:

harshala

See private message.

$85 USD in 135 days
(9 Reviews)
4.0

17 freelancers are bidding on average $524 for this job

illuminesoft

See private message.

$382.5 USD in 135 days
(362 Reviews)
7.7
brsofts

See private message.

$255 USD in 135 days
(274 Reviews)
6.6
kliksoftware

See private message.

$850 USD in 135 days
(12 Reviews)
6.1
regardsol

See private message.

$119 USD in 135 days
(94 Reviews)
6.2
rkumarvw

See private message.

$382.5 USD in 135 days
(45 Reviews)
6.0
snowsoftvw

See private message.

$594.15 USD in 135 days
(30 Reviews)
5.4
yitzsl

See private message.

$4250 USD in 135 days
(7 Reviews)
4.6
hassan2000vw

See private message.

$255 USD in 135 days
(12 Reviews)
4.4
eggvision

See private message.

$425 USD in 135 days
(12 Reviews)
4.5
keneto

See private message.

$119 USD in 135 days
(19 Reviews)
4.3
ClintS

See private message.

$85 USD in 135 days
(9 Reviews)
2.9
karinan

See private message.

$340 USD in 135 days
(2 Reviews)
2.9
wasimshah

See private message.

$93.5 USD in 135 days
(7 Reviews)
2.7
praveenmuz

See private message.

$212.5 USD in 135 days
(0 Reviews)
0.0
mewwork

See private message.

$127.5 USD in 135 days
(0 Reviews)
0.0
DouglasFeller

See private message.

$636.65 USD in 135 days
(0 Reviews)
0.0
zyuzin

See private message.

$85 USD in 135 days
(0 Reviews)
0.0