I need a small application to allow users to import/export data (patient demographics) from my software application. This will be a stand alone application that basically maps about 20 fields for import/export. These would be fields like FirstName, LastName, Address, etc. IMPORT The import features should work similar to how MS Excel imports a text comma (or tab)-deliminated file. In other words, if a user wishes to import a csv (or tab-deliminated) file, they would open the file and see columns of data with existing headings. The user would use drop-down combo boxes to select the matching field name in the database. So the IMPORT side is a near clone of Excel 2000's import wizard, with the addition of comboboxes to match the field names (since some imported files may use different names, e.g. FIRST instead of FirstName, etc). The import module should attempt to auto-match field names (i.e. select "FirstName" automatically in combobox if the import file's heading is "First". Sometimes the csv files may not have headers, in which case the user will have to manually match fields. Sometimes the csv files will have fields that do not have a match in my application; they are to be marked as "Ignore". Also, the field types will have to be set up properly (can use a system like Excel where the user selects "Text", "Date", etc. EXPORT The export feature will export a select number of fields (listed below) and output to a csv file. The data will be obtained from a MS Access database (a sample database included for you to test with). The user will be given the option of selecting which fields are to be exported: (1) ALL records in table (2) Records in table with an LastExam date = today (3) Records in table with a LastExam date = user selected range (4) Individual record (given the PatientID number) (5) Checkbox for "Exclude Inactive Patients" (to block export of inactive patients)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) 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
VB 6.0 MS Access