Results 1 to 2 of 2
  1. 01-19-2013, 01:59 AM #1
    jsimha
    jsimha is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    3

    export quety result to existing excel workbook

    Dear All,



    I am trying to export query result to existing workbook and in that to particular worksheet.

    When i try standard macro it is creating new file which is not my requirement.

    Attached sample database, appreciate your guidance.

    Regards,
    jsimha
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 01-19-2013, 06:49 AM #2
    alansidman's Avatar
    alansidman
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    crossposted to http://www.excelforum.com/access-tab...-workbook.html

    See my response there.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. export query into existing workbook
    By hklein in forum Programming
    Replies: 3
    Last Post: 05-08-2012, 04:55 AM
  2. Is there a way to create a macro to export query results into an excel workbook
    By K.Toth in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2012, 05:10 PM
  3. Export Query Result to Excel
    By chewbears in forum Access
    Replies: 11
    Last Post: 11-28-2011, 08:31 AM
  4. Exporting Query Results to an existing Excel Workbook
    By Dnphm in forum Import/Export Data
    Replies: 3
    Last Post: 07-13-2010, 11:40 AM
  5. Export a simple query result to an excel file
    By wop_nuno in forum Import/Export Data
    Replies: 1
    Last Post: 05-21-2009, 04:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums