I've been working steadily on a project involving the connection of an Access database to some external RFID hardware, invoking and then reading a .txt file and then parking parsed data in my database.
All has gone well thus far albeit I was working under the misunderstanding that there would only be one dataset to read consisting of one Header record and many Data records. My queries treated the Header record separately to all others and everything was sweet ...
However, it transpires that there could be multiple (unlimited) datasets and the resulting .txt file doesn't have common code between header and data records that I can use, simply stacking the data, presenting me with the difficulty of how to group/separate individual datasets.
An example .txt file is attached ...
Visually, it's easy to see which data belongs to which set and where the dataset breaks fall, but my question to you all is how can I write a Query (much preferred to VB code) to assign the same prefix to associated Header and Data records.
The prefix I'd like to use is the 56th character in each header row i.e. in my example data file this would be "T", "1", "2"
Thanks for taking the time to look at this ...
All has gone well thus far albeit I was working under the misunderstanding that there would only be one dataset to read consisting of one Header record and many Data records. My queries treated the Header record separately to all others and everything was sweet ...
However, it transpires that there could be multiple (unlimited) datasets and the resulting .txt file doesn't have common code between header and data records that I can use, simply stacking the data, presenting me with the difficulty of how to group/separate individual datasets.
An example .txt file is attached ...
Visually, it's easy to see which data belongs to which set and where the dataset breaks fall, but my question to you all is how can I write a Query (much preferred to VB code) to assign the same prefix to associated Header and Data records.
The prefix I'd like to use is the 56th character in each header row i.e. in my example data file this would be "T", "1", "2"
Thanks for taking the time to look at this ...