Excel 2007 - Importing Access Data

[mkallover]

I'm trying to import an Access query into Excel but unfortunately Excel does not support a WorkingDays function that I created with a Module in Access. Is there any way to finagle this and get around it?

 

[SkipVought]

Hi,

Check out the WORKDAY function.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mkallover]

That doesn't really help me. I'm trying to import a query from Access that uses a WorkingDays function. The Excel WORKDAY function doesn't help if I can't get the data into Excel.

 

[SkipVought]

WorkingDays must be a user defined function in that particular Access database. To the best of my knowledge, there is no WorkingDays built-in function in Access.

Access does have a Weekday function that returns 0 - 7, as does Excel.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

There was not reason to post over in the MS Access forum.

As I explained in your other thread, put the User Defined WorkingDays function in a module in your Excel workbook.

Import the Start and End date fields in your query.

In the column adjacent to your query results, use the WorkingDays function as you would any other woeksheet function.

In the Data Range Properties for the query table, check the ONLY BOX, at the bottom, to Fill down formulas in columns adjacent to data

Ease Peasy! I use this technique every day.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

alt+D D A

if you can't find it in 2007.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]