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.
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.
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.