I am trying to export to a text file from SQL Server 7 (or an Access ADP). As you can see from the file attached the Header Record (marked "H") has more fields than the detail record (marked "N"). I can put the data into 2 separate tables or the same table. Data from text fields is " " delimited. As the detail record has less records if everyting is in a single table the last few fields appear as a series of quotes. I also have had no luck with any type of join between 2 tables. Anyone any ideas? How the file should look attached.
Paul
