Hi

I've been using VBA for a few years, but only recently (within the past couple of weeks) stated using VB.net.

I've been given the job designing a small app to sit on a Win CE barcode scanner, save scanned barcodes & user entered data. Nothing too complex* and I'm looking for more advice on design rather than implementation (right now anyway...)

1. The scanned data needs to be held somewhere; a Dataset seems overkill for this task, so I was looking at using either a DataTable, or an array. Any suggestions about which is a better option? (or if there's a something else I've missed)

2. Once all the scans have been collected, they need to be saved to a file, which will be read elsewhere. I was considering using xml for the file, but as it's got to be readable by VBA, I'd started to reconsider using a csv. Does this seem like a good solution, and is there an easy way of producing csv/xml files from a datatable/array?

3. Has anyone here used the Symbol API for Motorola/Symbol barcode readers? It's confusing, the documentation is minimal, and I'm having problems doing even the simplest of things. I know it's a fairly niche concern but thought I'd try my luck.


Any suggestions gratefully received

Kev



*mostly, anyway. See 3 for where the misery is kicking in...