Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using excel to access MS Access saved query
I use the following code to open Access db and run a sql.
set dbs=opendatabase(dbname) set qry= dbs.createquerydef("queryname") qry.sql="select name from customers" set rst = qry.openrecordset() Activesheet.range("A1").copyfromrecordset rst It's working fine. However, I have multiple saved queries in MS Access that I would like to access from Excel VBA. I tried replacing "queryname" to the saved query name and it's not working. Am I missing something? Thanks |
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) | |||
Excel 2007 Quick Access Toolbar Changes not Saved | Excel Discussion (Misc queries) | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Run Access query from Excel, input value to query being value in c | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |