Results 1 to 5 of 5
  1. #1
    jabarlee is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    49

    Export to spreadsheet with no Excel present

    Hi everyone.

    Is it possible to export a table to a spreadsheet on a computer that has no Excel installed, but still be able to format the spreadsheet in detail?
    During my tests, I used CreateObject("Excel.Application") to be able afterwards to format the spreadsheet in detail.



    Do I have any alternatives?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    You tested on that computer? What happened? I would expect it to fail.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jabarlee is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    49
    Yes, I ran my Access application on a pc that had calc (Open Office) installed - and the Access runtime- and of course it failed, displaying several warnings that I cannot post right now (I'm at home).
    My problem is that this export method allowed me to format the spreadsheet exactly as I wanted.
    What other method could I use so I can export to a spreadsheet and still have the advanced formating options I want?
    As far as I can search DoCmd.TransferSpreadsheet and DoCmd.OutputTo methods will work even if the host computer does not have Excel installed, but they lack any proper formating options.

    Any way that would allow me to use a spreadsheet template would probably suit me.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    If install of Excel is required in order to open Excel objects to format then I don't see any way to accomplish without.

    If a suitably formatted template can be accessed with the TransferSpreadsheet and data exported to it without changing the formatting then that would seem to be only option.

    Not something I've ever attempted nor seen discussed.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Possibly export as a text file (no formatting) that could subsequently be imported to an excel sheet and formatted. I concur with June re: Needing Excel if you wish to preserve formatting.

    Alternatively, you could create a report in Access (formatted) and then export as a .PDF

    http://www.avantixlearning.ca/micros...sily-training/

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

Similar Threads

  1. Automate Export of a table to an Excel Spreadsheet
    By RayMilhon in forum Programming
    Replies: 3
    Last Post: 01-23-2018, 08:08 PM
  2. Replies: 6
    Last Post: 11-16-2017, 06:53 PM
  3. Replies: 2
    Last Post: 12-12-2014, 04:42 PM
  4. Replies: 1
    Last Post: 05-23-2013, 10:00 AM
  5. Replies: 1
    Last Post: 08-12-2010, 10:04 PM

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