Results 1 to 4 of 4
  1. #1
    Husseintech is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    4

    Red face send data from acces to excel

    hi for every body



    Thank you for this wonderful Forum,,, and I need help
    I want to send data from the Access Program to excel program
    I've work necessary code for it but I stayed there a problem of not being able to send data after the query
    so i mean i can send a data if it within a table but i cant send data from the query to excel

    i need a help for that if you please

    i hope my problem is clear



    for more Clarification i added attachment for editing ,,,,,
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    you can, just enter the query as the param.

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsMyQeuery", "c:\folder\file.xls", True, "tabname"

  3. #3
    Husseintech is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    4
    thank you ,,,
    but your code transfer the table as a whole to the excel not to specific cells you can see the attachment for mor information

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The first two lines of every module should be:
    Code:
    Option Compare Database
    Option Explicit
    Also, you have errors in your code


    For what you want to do, you should see Ken Snell's site:
    http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-01-2014, 02:27 PM
  2. Send an excel workbook from access
    By haazzaa in forum Access
    Replies: 1
    Last Post: 07-26-2012, 05:40 PM
  3. need to send to querie to excel
    By cslr in forum Queries
    Replies: 7
    Last Post: 11-07-2011, 11:21 AM
  4. Acces or excel, for handleing my data?
    By oo0tommyk0oo in forum Access
    Replies: 1
    Last Post: 07-07-2011, 11:27 AM
  5. acces listbox hatası(acces debug)
    By carso in forum Access
    Replies: 1
    Last Post: 09-22-2009, 04:11 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
  •  
Other Forums: Microsoft Office Forums