Custom Text in a Query

[jhlee2222]

Is there any way to add custom text to the top of a query's output?
I'm not talking about custom headers for each field in the query, but rather something like an overall heading that would appear as the top line or lines in a query, followed by the query results. I realize such a thing may sound like it would best be performed in a report, however, my goal is to output my query results as a CSV file. From what I've seen, exporting a report to CSV format just doesn't seem to work very well. My ideal output would look something like:

CUSTOM TEXT STATEMENT HERE.
SECOND CUSTOM TEXT STATEMENT HERE.
Field1, Field2, Field3
value1, value2, value3
value4, value5, value6
value7, value8, value9

[ItsMe]

Maybe the DoCmd.TransferSpreadsheet Method. I don't do much of this sort of thing but I imagine you could have a template with named fields (ranges) or you could create a file each time using ranges.

So, run it once to get your text. Then a second time to place your query results in the same file.
http://msdn.microsoft.com/en-us/libr.../ff844793.aspx

[June7]

Are you trying to use export wizard?

Maybe like (not tested):

SELECT "This is statement 1" AS FieldA, Null AS FieldB, Null AS FieldC FROM tablename
UNION SELECT "This is statement 2", Null, Null FROM tablename
UNION SELECT "Field1", "Field2", "Field3" FROM tablename
UNION SELECT Field1, Field2, Field3 FROM tablename;

Whether or not the export will retain that order for the output is unknown. Also don't know if the field names FieldA, FieldB, FieldC can be excluded from the output.

I think the range argument is for import from spreadsheet, not export to CSV.

[ItsMe]

I was looking at he TransferSpreadsheet and when you are exporting, there is not an option to choose ranges. It will always export to the first row. The ranges are only effective when Importing.

[jhlee2222]

June7, I was hoping something like what you described would work, and envisioned that as well. One major problem though is I really need the additional content on a line above the headings. And yes, I'm trying to use the Wizard, with it's very nice options for defining the type of delimiter, amongst other bells and whistles.

ItsMe, thanks for looking into this for me as well. I see why it's so hard to suggest anything. I believe what I need is such an odd one-off.

What I'm trying to do is make a template for data matching an import format for another program, and it requires special heading text to define the import file type, followed by column headers.

[ItsMe]

The export methods from a query object seem to consistantly output the header in the first row. Perhaps exporting a report to comma seperated text file and then using SHELL methods to copy and paste the entire text file, renaming as an .XLSX

[June7]

The wizard has its limitations.

The alternatives are:

1. possibly the suggestion by ItsMe to clean up the CSV text file with SHELL scripting after export

2. in VBA open a text file object and a recordset object and write one line at a time of data from the recordset to the text file