Access 2003 CSV Import

Completado Publicado Dec 28, 2008 Pagado a la entrega
Completado Pagado a la entrega

Introduction : barcode scanners produce csv file each time they are docked into eg. c:\from handheld ; each file is uniquely named eg. "packing 20081223 [url removed, login to view]" for 23rd Dec 2008 time 10.01 by scanner 42.$0Each csv file contains stockcode & quantity eg:$0$046443,200$0$046483,260$0$0$0$0$0Requirements :? $0$0(1) Every 15 minutes (or manually), latest batch of incoming csv files to be moved into a temp folder & ? read into Access2003 table, giving unique batch id, transaction details (in detailed requirements) ; original csv files then moved to archive folder;$0$0$0(2) from Access2003 issue the consolidated csv for the batch; this consol file to be uniquely identified ;$0$0$0$0$0This is an urgent but temporary requirement whilst our main software project is being completed.$0

## Deliverables

spec for consolidated csv file:$0$0$0$0AI, 46483, 23/12/2008, 42, 10.01, 260$0$0$0where$0$0AI=type Adjustment In$0$046483 = stock code (Alpha-Numeric field)$0$023/12/2008 = trans date$0$042 = barcode scanner? (Alpha-Numeric field)$0$010.01 = time? (Alpha-Numeric field)$0$0260 = quantity$0$0$0$0$0Access2003 or VB? we prefer Access so that data can be analysed etc but we're open to suggestions$0$0$0$0

Ingeniería Microsoft Access MySQL Odd Jobs PHP Gestión de proyectos Arquitectura de software Verificación de software

Nº del proyecto: #3500710

Sobre el proyecto

18 propuestas Proyecto remoto Activo Dec 29, 2008

Adjudicado a:

andrasrona

See private message.

$21.25 USD en 14 días
(6 comentarios)
3.1

18 freelancers están ofertando un promedio de $57 por este trabajo

fastudiovw

See private message.

$29.75 USD en 14 días
(748 comentarios)
7.5
Prashantskin

See private message.

$68 USD en 14 días
(531 comentarios)
7.1
pShankar2

See private message.

$85 USD en 14 días
(415 comentarios)
7.1
DavidWeiss

See private message.

$97.75 USD en 14 días
(60 comentarios)
7.0
qtorixsystems

See private message.

$3.4 USD en 14 días
(24 comentarios)
6.2
cuebiztech

See private message.

$5.1 USD en 14 días
(108 comentarios)
5.8
suryavijayvw

See private message.

$33.15 USD en 14 días
(130 comentarios)
5.7
Iwin

See private message.

$42.5 USD en 14 días
(61 comentarios)
5.7
j2eesoafree

See private message.

$102 USD en 14 días
(31 comentarios)
5.6
mrrcomputers

See private message.

$102 USD en 14 días
(43 comentarios)
5.6
homecoder82

See private message.

$17 USD en 14 días
(56 comentarios)
4.2
Robinson707

See private message.

$85 USD en 14 días
(7 comentarios)
2.8
tusharvb7

See private message.

$51 USD en 14 días
(5 comentarios)
2.5
synergydynamics

See private message.

$42.5 USD en 14 días
(8 comentarios)
2.2
deartec

See private message.

$42.5 USD en 14 días
(1 comentario)
1.4
TrickStar

See private message.

$127.5 USD en 14 días
(0 comentarios)
0.0
abdulqadar

See private message.

$68 USD en 14 días
(0 comentarios)
0.0