Use the 'Print Column Headers' option to write the column names from the selected query into a worksheet. This can be any worksheet and doesn't need to be in a Wizard format. It is a useful method to first create column headers and then write data into the same sheet using either of the above 'Download' buttons.
1. Create a new Worksheet.
2.Click the 'Print Column Headers' button.
3.Select the appropriate Query Set and Row number to print the headings in.
4.Click 'Continue' to write the column headings.
Note- Column headers are pasted into the nominated row commencing in column ‘A’ on a new sheet, or after the existing columns in a Wizard sheet.
5.You can now use the download options to write information into the sheet.
Notethe following:
(a)You will need to have your cursor below row 10.
(b)If you are using a ‘Non Wizard’ worksheet then you will need to dictate where you have created the headings. For example in the screenshot above the headings will have been written to row 9 so you need to ensure the query uses this row to determine the column names. This is provided on the ‘Settings’ tab of the Download form.
