Adding a "Header" and "Footer" to recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access table that is being manipulated as a recordset. It is a
list of customer details basically.

I need to be able to add a Header row (strHeader variable) to the start of
the recordset, and a Footer row (strFooter variable) to the end. The 2
variables are created elsewhere in my code.

This data will then be exported as a fixed width text file.

I dont have any convenient field that I can sort on to get the Header at the
beginning and Footer to the end of the file.

Is there a way I can use ADDROW to position the new data where I need it?

Thanks
 
Back
Top