 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007ms/access output to excel
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" > 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... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.