I'm looking for some advice on the best file format and import methods to use in my VB application. The sheer number of alternatives and the fact that I'm quite new to this type of programming is driving me nuts.
My application is business simulation that requires the administrator to input team decisions from printed forms. There are about 30 fields of data for each team and each team has a VB form to input the data. Once processed, the simulation generates reports and accounts for each team. This process is then repeated for each period in the simulation (up tom 12 periods)
I would like to store all the data for one simulation in one file and add to it when each period is played,b ut also keep the results from previous periods. I am thinking of storing the data from the VB forms in arrays as it is entered into the simulation software and then storing the results for each team into other arrays. These can then be displayed on the screen as tables. Then the whole lot would be written to a CSV file.
The CSV file would also contain summary data about that particular simulation (team names, current quarter, etc.) as well as the results of previous rounds.
My questions are:
Are arrays the best way to store the table variables?
Is a CSV file the best way to save this data to a file?
Does it matter in a CSV file if the rows do not all contain the same number of fields?
Would it be easier to use datagrids/tables instead of arrays?
If this is all too complicated, can anyone point me in the direction of a good article (or book) on how to process and file nlarge amounts of data.
I'd prefer not to use a database type application.
Any help greatly appreciated.