Results 1 to 2 of 2
  1. #1
    Grooz13 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    97

    Export access requery data to an excel cells every five minutes


    Ok i have dashboard in excel who gives me precious information about the status of the store, I had to change the way I worked so I changed for access. Now I want to do some requery and send those value to some excel cells so those dashboards would work and I would want to update it every 5 minutes is it possible?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Start your system with an invisible form that uses the timer. This form is very useful for any type of housekeeping chores you might have including what you seek. It is also the last form to close and can do cleanup chores as well. The AutoExec macro can start a form invisible.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Import Specific Cells from Excel to Access
    By Evocube in forum Import/Export Data
    Replies: 2
    Last Post: 01-12-2012, 10:35 AM
  2. Replies: 1
    Last Post: 08-17-2010, 02:33 PM
  3. Replies: 1
    Last Post: 08-12-2010, 10:04 PM
  4. Excel exporting in single cells
    By Paolo29011982 in forum Import/Export Data
    Replies: 0
    Last Post: 07-29-2009, 04:48 AM
  5. VBA Opening Excel File and Placing Data in Cells
    By BobTHG in forum Programming
    Replies: 0
    Last Post: 01-13-2008, 03:01 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