Passing Data to Excell from Access 2002 and then passing the results back to access.

Posted on 2006-03-22
Last Modified: 2010-04-25
I need to add 5 work days to a pending out date.  Since Excell has a workday function  I'm thinking I could pass the dates (could be a column of them) fields to a spreadsheet which has workday function set.

Once the spreadsheets runs the function I'd like to take the new dates and update a table in Access.

I'm fairly new and access and I think I need to do this in a module just not sure if this is possible or if anyone has another suggestion to accomisph the same thing.



daterec              number of dasy to increment              results new pending out date
03/03/2006                            5                                      03/10/2006

Question by:NLGroup
    LVL 53

    Accepted Solution

    Did you really want this post in the Macintosh Applications section? Access doesn't run on Macs. Suggest you repost to Databases: MS Access.
    LVL 53

    Expert Comment

    You may be able to do this in Access directly -- see: (search the page for "workday")

    Also see links at:

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
    Package creation on OS X uses the PackageMaker utility installed as part of the XCode development suite ( on the OSX Client CD).  Packages can be installed as part of the machine build process, or later using Apple Remote Desktop. They are generally…
    Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
    Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now