Access 2003 CSV Import

Completed Posted Dec 28, 2008 Paid on delivery
Completed Paid on delivery

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

Engineering Microsoft Access MySQL Odd Jobs PHP Project Management Software Architecture Software Testing

Project ID: #3500710

About the project

18 proposals Remote project Active Dec 29, 2008

Awarded to:

andrasrona

See private message.

$21.25 USD in 14 days
(6 Reviews)
3.1

18 freelancers are bidding on average $57 for this job

fastudiovw

See private message.

$29.75 USD in 14 days
(748 Reviews)
7.5
Prashantskin

See private message.

$68 USD in 14 days
(531 Reviews)
7.1
pShankar2

See private message.

$85 USD in 14 days
(415 Reviews)
7.1
DavidWeiss

See private message.

$97.75 USD in 14 days
(60 Reviews)
7.0
qtorixsystems

See private message.

$3.4 USD in 14 days
(24 Reviews)
6.2
cuebiztech

See private message.

$5.1 USD in 14 days
(108 Reviews)
5.8
suryavijayvw

See private message.

$33.15 USD in 14 days
(130 Reviews)
5.7
Iwin

See private message.

$42.5 USD in 14 days
(61 Reviews)
5.7
j2eesoafree

See private message.

$102 USD in 14 days
(31 Reviews)
5.6
mrrcomputers

See private message.

$102 USD in 14 days
(43 Reviews)
5.6
homecoder82

See private message.

$17 USD in 14 days
(56 Reviews)
4.2
Robinson707

See private message.

$85 USD in 14 days
(7 Reviews)
2.8
tusharvb7

See private message.

$51 USD in 14 days
(5 Reviews)
2.5
synergydynamics

See private message.

$42.5 USD in 14 days
(8 Reviews)
2.2
deartec

See private message.

$42.5 USD in 14 days
(1 Review)
1.4
TrickStar

See private message.

$127.5 USD in 14 days
(0 Reviews)
0.0
abdulqadar

See private message.

$68 USD in 14 days
(0 Reviews)
0.0