Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access query from Excel
I am trying to write a query and accesss database. I can query the database
and return a value to cell on a work sheet, but I would like the value assigned to variable instead. Can that be done without placing the value on a worksheet? I use the value in a formula. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access query from Excel
Hi mas,
mas wrote: I am trying to write a query and accesss database. I can query the database and return a value to cell on a work sheet, but I would like the value assigned to variable instead. Can that be done without placing the value on a worksheet? I use the value in a formula. Yes, but it will involve some VBA programming. You could hit the db with ADO, get the value you need, and store that value in a variable. You can do a google search or MSDN search on ADO to find tons of examples of how to do it. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Run Access query from Excel | Excel Programming | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Access query vs. Excel query | Excel Programming |