alanjbrown
asked on
reading and writing files of type record where there is a header or trailer record
How can I read or write files of type record where there is a header and or trailer record which has a different length and structure to the records in the body of the file?
Normally this is done in one of two ways. XML will allow you to mix this sort of data but it is wildly inefficient. If you want the speed of a database in what you are working on, this is normally achieved by writing the records to two different tables and loading them separately based on a common ID field. If you have large volumes of data each data file is normally accompanied by an index (to speed the lookups).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.