--- In [email protected], jeffandtamara <[EMAIL PROTECTED]> wrote: > > I am working with fixed width text files that are from an old format > type data that was restricted to an 80 column record length. The > result is there are multple rows for each unique record. In this case > there are 3 rows in the text file that make up each record. Is there a > way to read in the data directly? Or is the only hope to parse out > each row and keep track of where it is (row 1, row 2 or row 3) and > write out to a new file... > > I thought this was going to be easy..... >
Easy fix. Import the file as is. Use a make table query using your imported table but add an alias to create an extra empty field. Cycle through the recordset identifying the beginning and end of each record in the added field. Query the modified table to pull out your labeled records.
