We need to have a CSV file with three columns, imported into Access and Once in Access we need an interface to allow the lines of the files to be grouped an annotated with two additional columns that will be used to describe the lines of the table created from the CSV import. The files can be quite large from 100KB to 20 MB.
The utility we want is a VB or VBA tool that will drive the importation of the file into Access and will the provide an easy to use interface that will allow a user to annotate the imported data.
Use of ADO is okay. Focus will be on the GUI Interface for the end user. Has to be easy to use and allow for grouping the imported data and collapsing and expanding the view of the data.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete and fully documented source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) 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).
4) Source must be clean and easily handed off.
## Platform
Running on Windows XP platofrm with Access 2000 as a base platform. Sample CSV files will be provied on award.