I'd like to use data from a text flat-file in my VB app. I have a data dictionary that describes the content of the flat-file.
The challenge is that the flat-file structure may change in future (with an associated change in the data dictionary). Not frequently but every 6 months or so.
So I'd like my code to get the current flat-file structure from the dictionary before opening the flat-file itself.
What is the best way to store the flat-file data while I read it in record by record and use it in the app, given that I don't know the structure of the flat-file at design time?
Many thanks