Access 2003 CSV Import
$30-5000 USD
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
Project ID: #3500710