I am looking for a system that can import 3 different fixed width text files and import them into Access. From Access the user should be able to get a date range of data in the form of a report which then can be exported into Excel. The text files are prn type files and therefore the header type information does not need to be imported. There will be 3 different format files. All 3 files have the same code for indexing i.e. 2100 = cigarettes / tobacco. The end result is a management report with bits of information from each file. Please have a look at the attached 3 sample files as well as a sample output file. There should be a import facility which will allow the user to import a specific file type (i.e. purchase, sales or Mark up/down) for a specific day. The final report needs to be in Excel so that it can be easily portable. In Access there may need to be an additional table containing the following fields: Code Description Department. You will notice in the sample files that certain codes are grouped into departments. Departmental Sub totals and totals do not need to be imported as these will be recalculated when producung the output.
1) Complete and fully-functional working program(s) in executable form as well as complete 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) Complete ownership and distribution copyrights to all work purchased.
Win98 & XP VB Access 2000 Excel 2000