G
Guest
I need data from Access. The Access query is based on a table that must be
created first using a Make Table query. How do I run this query from Excel
VBA?
I tried:
200 Set db = OpenDatabase(Name:=strDbName1, _
Options:=False, ReadOnly:=True)
Set qry = db.QueryDefs(strQryName1)
Set rs = qry.OpenRecordset(dbOpenSnapshot)
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
but it fails at:
Set rs = qry.OpenRecordset(dbOpenSnapshot)
I can get the 2nd query to run when the table is created within Access.
However, I need to do all of this on the Excel side.
Thanks
created first using a Make Table query. How do I run this query from Excel
VBA?
I tried:
200 Set db = OpenDatabase(Name:=strDbName1, _
Options:=False, ReadOnly:=True)
Set qry = db.QueryDefs(strQryName1)
Set rs = qry.OpenRecordset(dbOpenSnapshot)
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
but it fails at:
Set rs = qry.OpenRecordset(dbOpenSnapshot)
I can get the 2nd query to run when the table is created within Access.
However, I need to do all of this on the Excel side.
Thanks