Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access data queries with functions in excel
- Thread starter Spidy6123
- Start date
Can you give a more detailed explanation please ? what is it that you are trying to do ?
Are you querying data from Access into Excel via ODBC ?
If so, what Access functions do you think are not available in Excel ?
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Are you querying data from Access into Excel via ODBC ?
If so, what Access functions do you think are not available in Excel ?
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #3
I have access doing some data sorting via an access query..
This query is then transfered to excel using an ODBC connection linked to that mdb..
the problem is, this query uses a function from a module within the mdb and ODBC is not allowing it through..
My question is, how to I allow the function through the odbc connection?
Actually another option is to figure out how to count network business days between two dates via sql.. this way I would avoid the need for the function all together..
If anyone has any advice.. I would appreciate it..
This query is then transfered to excel using an ODBC connection linked to that mdb..
the problem is, this query uses a function from a module within the mdb and ODBC is not allowing it through..
My question is, how to I allow the function through the odbc connection?
Actually another option is to figure out how to count network business days between two dates via sql.. this way I would avoid the need for the function all together..
If anyone has any advice.. I would appreciate it..
If this needs to be brought into excel you will not be able to use a custom function you have created in Access. If, however, you can bring both dates back, you can use the NETWORKDAYS function in excel to get your results. This, combined with the 'copy down formulae' attribute of the querytable (the object created when returning data to excel using ODBC) should give you what you need.
You will need to make sure you have the ANALYSIS TOOLPAK add-in installed to use the NETWORKDAYS function and the querytable property is set by right clicking on the data after it is returned and choosing 'Data Table Options'
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
You will need to make sure you have the ANALYSIS TOOLPAK add-in installed to use the NETWORKDAYS function and the querytable property is set by right clicking on the data after it is returned and choosing 'Data Table Options'
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Status
Similar threads
