Wrox Programmer Forums
|
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 5th, 2005, 08:46 PM
Registered User
 
Join Date: Aug 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transferring Access Report to Excel

Does anyone know how to automatically transfer a report (that has groupings and calculations) to an excel spreadsheet.

Someone recommeded I use the:
  DoCmd.TransferSpreadsheet

But I think it may be only for tables and SQL commands. The SQL command doesn't work because I need subtotals.

ANyone have any recommendations.

Rhonda







Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Chart Object In Access Report dorlesky Access VBA 0 July 26th, 2007 10:26 PM
Transferring data from text file to Excel imranshah Excel VBA 0 July 5th, 2006 10:22 AM
Export Access Report to Excel - Total column moves rklass BOOK: Access 2003 VBA Programmer's Reference 1 June 9th, 2006 08:50 AM
Converting excel data to Access using excel VBA ShaileshShinde VB Databases Basics 1 April 26th, 2006 07:57 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.