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.
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).
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.