Help and advice needed on building a vb.net app to port datasets around between various different applications. I'm looking for ideas on what approach to use, ideally plus example code.
I think a sensible way to do this is to setup classes for each of the applications - each class can import from a file to a common format (eg dataset), and export from that common format out to a file. I can then easily move data between the formats.
File formats I'm using so far are Excel, Access, SPSS and .csv.
1. Is that a good way to do it? Any comments / better ideas ...
2. Seems straightforward to import data from Excel and Access to a dataset. But how would I go the other way, eg saving dataset/table to a new Access table / Excel worksheet? Ideally wouldn't have to go through all the fields / records manually ...
3. Anyone have any pointers on how to do this with SPSS (I guess that's a long shot ;-)