ms/access output to excel

  • Thread starter Thread starter ssimmons
  • Start date Start date
S

ssimmons

HI,
I would like to output some of my tables to different worksheets
within the same excel file. does anyone know how I can do this from
access. Thanks Sam...
 
Insert the following into the "on-click" event of a button. It also includes
the date and time in the file name.

Dim sToday As String

sToday = Format(Now, "yyyy.mm.dd hh.mm")

DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "QUERY NAME", _
"C:\DESTINATION - " & sToday & ".xls", True, "SHEET NAME"
 
Back
Top