Access DB Records from txt (for azrafe7) (for azrafe7)

Cancelado Postado Jul 8, 2007 Pago na entrega
Cancelado Pago na entrega

Requirements:

Read each cap file into records in a table in Access DB;

rename .cap file to .txt into named folder Processed after each file processed;

see qryDACSData1 query in DB for filter criteria for records;

add the filter records into the tbl_DAC_Data table;

need simple form to search on Circuit# and list all records for the circuit in ascending order of filedate.

## 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 Sunday Jul 8, 2007 1:15:48 PM:

note: if .cap file does not have 'real' records then move the file to different named folder like Invalid or NotProcessed

* * *This broadcast message was sent to all bidders on Sunday Jul 8, 2007 1:31:11 PM:

Any files that do not have data that includes the Circuit and ErrorCode with are concantenated from fields 10, 11, 14, 15; should be moved to invalid/notprocessed named folder. (I forgot to include the empty folder.) the qrys in the database are meant to give you example of criteria to include in VBA code to process each file, determine if it has 'real' records, if so, move file to Processed folder but if not, move file to a folder called Invalid or NotProcessed.

## Platform

Windows Professional

MS Access XP

Engenharia Microsoft Access MySQL PHP Arquitetura de software Teste de Software Visual Basic para Apps

ID do Projeto: #3103253

Sobre o projeto

1 proposta Projeto remoto Ativo em Jul 8, 2007

1 freelancer está oferecendo em média $21 para esse trabalho

azrafe7

See private message.

$21.25 USD em 1 dia
(23 Comentários)
3.6