Hi DJ,
A blank row in a CSV file would be something like this:
,,"","",,"",,
If that's what you want, you can get the result by creating a dummy
table with the same fields as the main table but containing just seven
null records. Then use a union query to combine the seven empty records
with the real ones, with an ORDER BY statement to ensure that the blank
records come first.
If you want seven empty lines at the start of the textfile, it's not
strictly speaking a CSV file (part of the definition is containing one
table with one optional header row and nothing else). One way to achieve
it is to create a textfile containing just the seven empty lines (e.g.
with Notepad) and store this in the same folder as the database. Then
export the data to a temporary file (e.g. "$$$DATA.TXT") and use
something like this to concatenate the two files and delete the temp
file:
Shell "COPY ""D:\Appfolder\BlankLines.txt"" + " _
& """D:\Folder\Sub folder\$$$DATA.TXT"" " +
& """D:\Folder\Sub folder\My export file.txt"""
Kill "D:\Folder\Sub folder\$$$DATA.TXT"
