Results 1 to 5 of 5
  1. #1
    DHaedo is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11

    Export Access into a specific cell in a specific table in Excel

    Hi,
    I have a table in Microsoft Access 2007 that I want to be able to export directly into Microsoft Excel 2010. The table in access might vary in rows, but the columns will remain the same. I created a cmd button with this coding behind it:
    Private Sub cmdExport_Click()


    Dim outputFileName As String
    outputFileName = Me.Form.txtFile
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_PSAB_Asset_Roll_Up", outputFileName, True
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_PSAB_Asset_Detailed", outputFileName, True
    DoCmd.TransferSpreadsheet


    End Sub
    But this only appends two new tables into excel. I want to append one of the tables values into excel (the excel table has formula's that will further break up certain costs, this is for ease of the user).
    Is this even possible?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Yes, with automation.
    See Ken Snell's site http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    "I want to append one of the tables values into excel" - What do you mean by this? If you do not want all the records and fields from the tables, create and use queries that include the correct recordsets instead of the tables in your statement?

  4. #4
    DHaedo is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11
    When I paste directly into an excel table with formula's already in the cells, I do not want those formula's being pasted over, I just want the values

  5. #5
    DHaedo is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11
    This is exactly what I needed. Thanks Steve

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

Similar Threads

  1. Replies: 1
    Last Post: 11-20-2014, 08:34 AM
  2. Replies: 1
    Last Post: 10-28-2013, 12:32 PM
  3. Export Query to .ODS file starting at a specific cell
    By Baldeagle in forum Import/Export Data
    Replies: 4
    Last Post: 03-20-2013, 01:03 PM
  4. import specific cell from excel to access
    By maneuk in forum Import/Export Data
    Replies: 10
    Last Post: 07-01-2011, 06:24 AM
  5. Export a value to specific Excel cell
    By gg80 in forum Import/Export Data
    Replies: 5
    Last Post: 07-23-2010, 01:58 PM

Tags for this Thread

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