CREATE EFILE TABLE FROM ACCESS DATA

THIS PROGRAM WILL LOOP THRU AN ACCESS TABLE, TAKING THE INFORMATION STORED ON AN ACCESS TABLE RECORD, CONVERTING IT TO THE REQUIRED DATA TYPE, AND RECORDING IT IN A RECORD FOR ELECTRONIC TRANSMISSION. A PDF COPY OF THE DESTINATION FILE DOCUMENTATION IS ATTACHED. THE ACCESS TABLE WILL BE SUPPLIED. CALCULATIONS ARE NOT PART OF THIS ASSIGNMENT. IN ADDITIONS TO THE FIELDS MARKED "M" ON THE ATTACHED ZIPPED PDF, SOME ON THE UNUSED FIELDS WILL BE USED TO STORE THE EMPLOYER AND EMPLOYEE IDS, THE AMOUNT OF TAX DUE, AND THE ROUTING AND ACCOUNT NUMBERS. ## 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). * * *This broadcast message was sent to all bidders on Thursday Aug 3, 2006 9:56:40 AM: QUESTION: WHAT SHOULD BE THE FORMAT OF THE OUTPUT? AN ACCESS TABLE OR A TEXT FILE ON THE FILE SYSTEM? $$$$$$$$$ PLEASE SEE THE RECORD SENT, I BELIEVE A TEXT FILE. ****** AND IN CASE OF A TEXT FILE, WHAT ABOUT THE NAME AND LOCATION? USER ENTERS IT OR FIXED? $$$$ FIXED NAME: "YYYYQ UC ELECTRONIC FILE" THE YYYYQ IS A VALUE FOR ONE OF THE TERMS IN THE RECORD. IT IS THE SAME FOR ALL RECORDS IN THE TABLE. OVERWRITE PREVIOUS VERSIONS, AFTER WARNING. LOCATION IS THE SAME AS THE LOCATION OF THE SOURCE MDB. * * *This broadcast message was sent to all bidders on Thursday Aug 3, 2006 9:57:04 AM: QUESTUIONS ANSWERED 1.) What format should the results file be in? txt ? UNKNOWN - SEE THE SAMPLE RECORD 2.) Should the file have any type of delimiter or just the field positions? FIELD POSITIONS ONLY 4.) Will you have data that fills every field or just select fields? THE FIELDS MARKED "M" PLUS ONE A BLANK AREA, CLIENT NUMBER, A LONG INTEGER h ## Platform WIN98 AND LATER, ACCESS, VB6