Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

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

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.

example:

Spreadsheet

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



0
NLGroup
Asked:
NLGroup
  • 2
1 Solution
 
strungCommented:
Did you really want this post in the Macintosh Applications section? Access doesn't run on Macs. Suggest you repost to Databases: MS Access.
0
 
strungCommented:
You may be able to do this in Access directly -- see: http://www.candace-tripp.com/pages/access_downloads.aspx (search the page for "workday")

Also see links at:  http://www.google.com/search?hl=en&q=ms+access+workday+function&btnG=Google+Search
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now