var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Export a recordset to excel
I have a recordset i would like to export to excel is there a way to do this?
If you are working under Access and this recordset is stored in a table then use
DoCmd.OutputTo acOutputTable, yuourTableName , acFormatXLS,
path & Export_fileName & ".xls"
no its not in a table its a rs how can that be done?
Got through the rs and write in a file .txt or . csv
(Comma Separated Values), which could be read or imported in Excel
something like that
Open "DATEI1" For Output As #1 ' Open für Output.
do while not rs.EOF
ˇˇ Print #1, rs("Field1") & "," & rs("Field2") & "," rs("Field3")