You would need to add it yourself, for example DatabaseRetrieve( "select \"col1_header\", \"col2_header\" union all select col1, col2 from table1", retrieved_rows ) Another solution is to create a preformatted Excel file with headers, fonts, cell formats, formulas, etc... and an "on startup" macro. From a job you can save the exported data into temp XLS of CSV file and then start the preformatted file and have the macro load the data from the temp one. : Is it posible when exporting rezults form SQL Select to include header row? : -----------------------------------------------------------------------
: Dim retrieved_rows, number : Dim exported_rows, number : // Connect to database : DatabaseConnect( "abc" ) : // Reterieve data : DatabaseRetrieve( "select col1, col2 from table1", retrieved_rows ) : // Save current month data in Excel file : DatabaseSave( "c:\\Reports\\table1.xls", "xls",
: exported_rows ) : // Disconnect from database : DatabaseDisconnect
: ------------------------------------------------------------------ : File table1.xls contains data but no column names (col1,col2)
|
