PayrollUser
Technical User
I need to produce an ASCII file from Access 97 with a header and footer. I am able to produce the body of the ASCII text file by using the VBA command: DoCmd.TransferText acExportFixed, "name", "qryname", "c:\temp\file.txt", False
However, I also need to add a header (which gives the current date and time) and a footer (which counts the number of records)to this ASCII file.
Any tips on how to do this would be greatly appreciated.
However, I also need to add a header (which gives the current date and time) and a footer (which counts the number of records)to this ASCII file.
Any tips on how to do this would be greatly appreciated.
