One of our vendors needs data from a table with a header (as HD) and a footer (as FT). The header is easy but short of converting the query to a report, how do I send CSV file with a footer as the last line. Thnks in advance.
Competent Performer
Windows 7 
Access 2007
One of our vendors needs data from a table with a header (as HD) and a footer (as FT). The header is easy but short of converting the query to a report, how do I send CSV file with a footer as the last line. Thnks in advance.
VIP
Windows XP Access 2010 32bit
CSV file is a text file that can be edited with word processor app. Notepad will do. If you want to automate adding line to the CSV, need to open the CSV file as an object in VBA write new line then close the object.
Google: Access VBA append to text file
http://www.devhut.net/2011/06/06/vba...o-a-text-file/
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
header and footer
How to make the area between header and footer bigger
Toggle Visibility of Group Header/Footer Based on Criteria?
Posting Permissions
Reply With Quote