Em Andamento

Import File to Access

I have a fixed length flat file originated from a mainframe program. The file comes from the bank and is essentially a reconciliation statement. The file contains data for paid checks and unpaid checks. These are processed by the bank in batches. The file contains a mix of "paid batches" and "unpaid batches" for some time period. The structure of a batch is header record, details (each check), and summary record. The header record distinguishes if the particular batch is paid or unpaid... meaning, looking at a detail record alone, you would not be able to tell if it was paid or unpaid, unless you saw the header record.

Given this, what I need to have done is an MS Access database created with probably three tables - paid table, unpaid table, and header/summary table. Need an import macro written which will pull the file in and load it to the respective tables. Tables will need to be relational (paid detail to its respective header/summary and unpaid detail to its respective header/summary).

## Deliverables

Specific Deliverable:

- Access db

- Import macro w/ table loader

- Apprx. 3 relational tables

General Deliverable:

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 (if appropraite).

3) Complete ownership and distribution copyrights to all work purchased.

## Platform

MS Access 97 or 2000 (no higher)

Win 2000

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: what is the meaning of data structure, what is record in data structure, meaning of data structure, data structure meaning, what is ms access, summary table, structure engineering, reconciliation, data loader, batch file, bank reconciliation, import access database php, access reconciliation, import flat table, flat file access, 2000 fixed, batch import php, access summary, table fixed header, check processed, access form record, import database access php, bank software source code, batch file import file access, batch import file access

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #2966668

Premiar a:

arcan08

See private message.

$85 USD em 2 dias
(28 Avaliações)
3.4

79 freelancers estão ofertando em média $129 para este trabalho

psergei

See private message.

$170 USD in 2 dias
(449 Comentários)
8.6
softservicesvw

See private message.

$127.5 USD in 2 dias
(335 Comentários)
7.7
jeivw

See private message.

$212.5 USD in 2 dias
(131 Comentários)
7.6
amritb

See private message.

$170 USD in 2 dias
(45 Comentários)
6.8
derektpvw

See private message.

$106.25 USD in 2 dias
(108 Comentários)
6.5
kkmclegg

See private message.

$127.5 USD in 2 dias
(40 Comentários)
6.4
tobsvw

See private message.

$170 USD in 2 dias
(67 Comentários)
6.0
stevewvw

See private message.

$148.75 USD in 2 dias
(109 Comentários)
5.9
creativexso

See private message.

$199.75 USD in 2 dias
(81 Comentários)
5.9
danvlas

See private message.

$85 USD in 2 dias
(75 Comentários)
5.6
snowsoftvw

See private message.

$85 USD in 2 dias
(30 Comentários)
5.4
mocak2

See private message.

$102 USD in 2 dias
(41 Comentários)
5.4
pursca

See private message.

$212.5 USD in 2 dias
(30 Comentários)
5.2
DeanMan

See private message.

$85 USD in 2 dias
(68 Comentários)
5.2
gopikap

See private message.

$85 USD in 2 dias
(54 Comentários)
5.1
edifus

See private message.

$127.5 USD in 2 dias
(28 Comentários)
5.0
jscurless

See private message.

$170 USD in 2 dias
(27 Comentários)
5.0
prasanna123

See private message.

$85 USD in 2 dias
(58 Comentários)
5.1
HGDiaz

See private message.

$85 USD in 2 dias
(31 Comentários)
4.8
michaelkitis

See private message.

$187 USD in 2 dias
(13 Comentários)
4.7