Results 1 to 4 of 4

Exporting my Access Report into an Excel Template

  1. #1
    Peter Simpson is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Oct 2017
    Location
    South Africa
    Posts
    83

    Exporting my Access Report into an Excel Template

    Hi Guys



    I know his has been covered before as I have seen he thread, but I really am stuck and did not understand the thread. Please can you help me, bearing in mind that I am a newbie.

    I have an Access Report that pulls from a query with parameter values. (The query forces the user to select a date range in order to show the running hours of a machine.) I get the report to work nicely.

    I also have an Excel sheet that I have designed a template in that I would like my Access Report to populate.

    I can export to Excel no problem....How do I work with a template? Do I create the template first then try get Access to populate it? If so ...How?

    Thanks a million
    Peter

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,538
    Bing: Access VBA export Excel template.

    Here is one https://social.msdn.microsoft.com/Fo...excel-template

    Alternatively, have Excel pull data from Access.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    Peter Simpson is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Oct 2017
    Location
    South Africa
    Posts
    83
    Thank you for your effort June7 but I have no idea how to apply that .....as i said I am very new. I dont even know where to start

  4. #4
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    223
    Well, this is going to require automation. So, let's start with... When you want to export a parameter query to Excel you are going to need a Form to input the date range. So, create a Form with two UNBOUND text boxes. Note, the Form needs to be unbound. You are also going to need to set up your Template in Excel. Now, once you have those things set up please post the SQL of the query. Going to meed more later on but this should get us started.

    Side note, this is going to a day or two and sometimes I get busy but I will stay with you till it's done!
    Gina Whipp
    Microsoft MVP (Access 2010-2015)
    https://www.access-diva.com/tips.html

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

Similar Threads

  1. Exporting Query From Access to Excel Template
    By manics31 in forum Import/Export Data
    Replies: 2
    Last Post: 09-25-2018, 04:49 PM
  2. Exporting a Access Report to an Excel File
    By Coffee in forum Import/Export Data
    Replies: 2
    Last Post: 07-28-2014, 10:32 AM
  3. Replies: 3
    Last Post: 09-08-2013, 07:50 AM
  4. exporting access report to specific excel cells
    By grgold14 in forum Import/Export Data
    Replies: 1
    Last Post: 02-07-2012, 03:38 PM
  5. Exporting to a custom Excel template
    By theronlightfoot in forum Import/Export Data
    Replies: 2
    Last Post: 04-12-2010, 10:51 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
  •  
Tech Forums: Microsoft Office Forums